SUMIFS Help

Ian Cummings

Hi all,

Having an issue with a formula;

I want to sum column 3 based on fulfilling criteria from 2 other columns eg

If Column A says "Product" and column B says "2024 May" then sum column Column C

It may seem simple, but having issues...

Thanks

Colleen Patterson

=SUMIFS([Column C]:[Column C],[Column A]:[Column A], "Product", [Column B]:[Column B], "2024 May")

In my example I have brackets around the column names since there is a space in the way that I have them labeled. If yours doesn't for example the name of Column A is Item, then you would use Item:Item.

Nick Korna

Hi @Ian Cummings

The formula should be:

=SUMIFS([Column C]:[Column C], [Column A]:[Column A], "Product", [Column B]:[Column B], "2024 May")

To sum the rows which fulfil the criteria.

What issues are you having? I am guessing you have some kind of error message, can you advise what it is if so.