CountIF function

R

RussianMonkey

I wonder how possible it is to count the number of cells with a date
depending on the result of another cell in the same row without using a Pivot
Table.

Ie, If I wanted to count the number of times Bread was delivered on
01/03/07, how would I be able to do this?

Thanks!

RM
 
D

Don Guillett

to count
=sumproduct((a2:a22=b1)*(b2:b22="bread"))
to sum col c based on the criteria
=sumproduct((a2:a22=b1)*(b2:b22="bread")*c2:c22)
 
Top