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!