Excel Question - SUMIFS
I am trying to sum a column of values if two criteria are met but it is not working...
=SUMIFS('Kit List'!$H$5:$H$50,'Kit List'!$F$5:$F$50,$A$4,'Kit List'!$A$4:$A$49,B4)
I want to sum Kit List H5:H50 if
Condition 1: Kit list F5:F50 is equal to cell A4
Condition 2: Kit list A4:A49 is equal to cell B4
I have two worksheets,
First is Kit List, which has Month value in Column A , Variable in Column F and the costs that need to be summed in column H
Second is Payments, I have Supplier in A4 and the month value in B4.
Any help would be very appreciated!