When using dates as criteria for the COUNTIF and SUMIF functions, Excel does some interesting things, depending on whether you are using "=" or "3/1/17") Formulas for OR conditions are a bit more tricky (see below). NOTE The SUMIFS, COUNTIFS, and AVERAGEIFS functions are used for multiple AND conditions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |