Getting the sum of Column B when Column A is January

[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

 

[Frank Kabel]

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

 

[Dave R.]

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

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