formula

R

Ryan

Help,
I'm new to excel and need formula help. I have dates in column A and
text in column I and K. I want a formula to find out how many times
an item occurs per month in column I and K.
 
F

Frank Kabel

Hi
one way (if you want to add the item occurences of column I and K):
=SUMPRODUCT((MONTH(A1:A1000)=1)*((I1:I1000="item")+(K1:K1000="item")))
for January
 
Top