Forum Discussion
cher818
Oct 29, 2021Copper Contributor
Pivot Tables and COUNTIFS
Two topics I'm struggling with. 1. COUNTIF formulas. I'm referencing data from another worksheet in the same excel file. I am having trouble with the criteria 2 part of the formula. =COUNTIFS(...
Yea_So
Oct 29, 2021Bronze Contributor
Syntax
=COUNTIFS (range1, criteria1, [range2], [criteria2], ...)
Arguments
- range1 - The first range to evaulate.
- criteria1 - The criteria to use on range1.
- range2 - [optional] The second range to evaluate.
- criteria2 - [optional] The criteria to use on range2.
Notice the range is just 1 column, column A and column A has many fruits but the countifs is only specifying "Apple" as the criteria, so there are 12 instances of "Apple" in the range.
Your formula is ranging the whole table looking for "download"? which column will "download" be found that is your criteria range so your range should be $F$2:$F$5000
On the table, please share a sample dataset.