Sumifs Criteria

[wrightjames]

Hi Mr Excel

It's not easy to describe my question. It's best for me to ask by attaching two images and relating my question. Attached are two snip images called "Sumifs Criteria 1" and "Sumifs Criteria 2". On number 1 I'm trying to do a Sumifs argument but there is no answer even though the Criteria Range ("Feb";"Jan";"Jun","Jun","Jun") is displaying the correct text values which equates to the Criteria. On the second image the answer is displayed while again the Criteria Range is again showing the correct values.

What do I need to do in order to manipulate the Sumifs Criteria Range in the FIRST image to correctly display the answer of -1000. Can the sumifs formula handle a TEXT range?

Thanks James

 

[mrshl9898]

Try:

=SUMIFS(J4:J8,K4:K8,">="&I2,K4:K8,"<"&DATE(YEAR(I2),MONTH(I2)+1,DAY(I2)))

*assuming Jun-20 is 01/06/20

 

[wrightjames]

Thank you very much for your rapid response. And yes it does work.

Cheers!!!