Sum IF lookng at thethe using the month

[pmw19800]

Hello
B26 needs to sum Colum L based on the month, (I have tried a formula) epic fail

C26 needs to count based on the Colum c based on the month number


please see attahed to help understanding

Cheers for looking

[AliGW]

No attachment ...

[pmw19800]

man you are fast, i was just uploading it

[AliGW]

Are you aware that you can attach the workbook BEFORE submitting the post?

[pmw19800]

yes, i forgot and noticed secends after i posted,

But you had already noticed LOL :-(

[AliGW]

Do you mean this in B26 copied down?

=SUMPRODUCT((MONTH($C$2:$C$3)=ROW(A1))*$I$2:$I$3)

[pmw19800]

that works well, thanks

[AliGW]

Thanks for marking this thread as SOLVED.

You may or may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.