Count Column B items if Column A are from the same month

  • Thread starter Thread starter Simon.
  • Start date Start date
S

Simon.

Dear ALL,

I am now working on a worksheet that require to write a
fomula to count the occurence of Column B item if the
Month of Column A is the same.
However the time format in Column is dd/mm/yy.

So May I ask how should I count occurence of Column B when
the item in Column A are from the same month?

Thanks so much for your help.
Waiting for your reply.
cheers,
Simon Lee
 
One way

=SUMPRODUCT(--(MONTH(A1:A30)=2),--(B1:B30="x"))

count x in B where month in A is Feb. If you just want to count months in A
that are
Feb

=SUMPRODUCT(--(MONTH(A1:A30)=2))

if you want to count month of Feb in A where B is anything but empty

=SUMPRODUCT(--(MONTH(A1:A30)=2),--(B1:B30<>""))
 
Back
Top