SUMIFS Formula Help Please

[carlhamill]

Afternoon, I wonder if you guys could help me.

Im trying to sum the numbers - Material Variance (column I) based on two criteria, if it was done on Machine 99 (Column A) and the reason is CONSUMPTION (Column K) .

Please see attached test spreadsheet.

As you can see I've tried to do a SUMIFS forumla in cell M8. Needless to say it didnt work as planned. =SUMIFS(Table1[Material Variance (£)],A:K,"99",A:K,"CONSUMPTION")

Thanks in advance for any help you can offer

[AliGW]

I will take a look for you. In the meantime, would you please reply to the message I sent you privately yesterday? Thank you.

[AliGW]

This should do what you want:

=SUMIFS(Table1[Material Variance (£)],Table1[Machine Number],99,Table1[Reason],"CONSUMPTION")

[63falcondude]

Try this:

=SUMIFS(Table1[Material Variance (£)],Table1[Machine Number],99,Table1[Reason],"CONSUMPTION")