SUMIFS

toby45106

I keep getting an error when I try this formula. I basically want to Add Contract Amount if the YR = 18 and the MO <4.

Any suggestions?

 

Chris McKay

Hi Shirley,

Something like this perhaps:

=SUM(COLLECT([Contract Amount]:[Contract Amount], [Contract Date]:[Contract Date], YEAR(@cell) = 2018, [Contract Date]:[Contract Date], MONTH(@cell) < 4))

Kind regards,

Chris McKay