Getting the sum of Column B when Column A is January

  • Thread starter Thread starter Simon Lee
  • Start date Start date
S

Simon Lee

For this fomula
=SUMPRODUCT(--(MONTH(A1:A4)=1),--(B1:b4<>""))

it is for counting the no of Column B when the Column A's
cell is January.

But how should I change this fomula, so that instead of
counting its occurence, it sums up the number inside the
respective cells?

I am now stuck in my work now.
Thanks so much for your help.

Regards,
Simon Lee
 
Hi Simon
assuming that your cells for summing are in column C use the following:
=SUMPRODUCT(--(MONTH(A1:A4)=1),--(B1:b4<>""),(C1:C4))

HTH
Frank
 
Ehm...I think the numbers are in B.. if theyre blank it wont affect the sum

=SUMPRODUCT(--(MONTH(A1:A4)=1),(B1:B4))
 
Back
Top