Hello,

I'm trying to create a formula that will count the number of rows for which 3 columns match.

The first column (C) contains dates; the second (O) and third (P) columns contain numbers

Here is what I've got so far to pull count the number of rows where C is in January, O=1 and P=1, but the value returned is always "zero".


=SUM((Sheet1!C:C=COUNTIFS(Sheet1!C:C,">=1/1/2014",Sheet1!C:C,"<=1/31/2014"))*(Sheet1!O:O=1)*(Sheet1!P:P=2))

So apparently you can't use countifs in there?

I've tried various "count/countif" formulas as well.

Sample data would be (count=1)

C O P
1/1/2014 1 1
1/1/2014 1 2
5/1/2014 1 1

Any thoughts would be appreciated.