formula

  • Thread starter Thread starter Ryan
  • Start date Start date
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.
 
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
 
Back
Top