Calculating How Much Each Person Brings in a Month

[Big D]

Worksheet.jpg

Need help with this....

I am trying to write a formula that will add all January payments (cash credit and check) received by RG and JH (Separately).

Then I want to add February, March, etc.

This is what I have so far. It seems to work unless you add a February in the mix and it adds it too.

=IF(MONTH(A$9:A$28=1),SUMIF(G:G,"RG",D:D)+SUMIF(G:G,"RG",E:E)+SUMIF(G:G,"RG",F:F))

Thanks for any help!

[ChemistB]

Try
=SUMPRODUCT(--(MONTH($A$1:$A$28)=1), ($G$2:$G$28="RG")*($D$1:$F$28))

Does that work for you?

[Big D]

Thanks for the reply. I tried it and got #value error.

[ChemistB]

Sorry, needed some tweaking. Try this

=SUMPRODUCT(--(MONTH($A$2:$A$28)=1)*($G$2:$G$28="RG")*($D$2:$F$28))

[Big D]

Hurray! It seems to work. Thank you so much!