If criteria can be from either field, can you just cut/paste them to be below each other? Otherwise, have to call all possibilities
=SUMIF(E3:E5,F9,F3:F5)
+SUMIF(E3:E5,F10,F3:F5)
+SUMIF(G3:G5,F9,H3:H5)
+SUMIF(G3:G5,F10,H3:H5)
If criteria can be from either field, can you just cut/paste them to be below each other? Otherwise, have to call all possibilities
=SUMIF(E3:E5,F9,F3:F5)
+SUMIF(E3:E5,F10,F3:F5)
+SUMIF(G3:G5,F9,H3:H5)
+SUMIF(G3:G5,F10,H3:H5)
Hi ,
Try this :
=SUM(SUMIF(OFFSET(E3:E5,,{0,2}),F9,OFFSET(E3:E5,,{1,3})) + SUMIF(OFFSET(E3:E5,,{0,2}),F10,OFFSET(E3:E5,,{1,3})))
Narayan
Yes...my formula allowed for criteria to be from either field. Did you check?Thanks Luke, but as i mentioned in the excel attached that the values can be from different filed (filed 1 or filed 2) and the list is complete dynamic in terms of records may be 2,3 or 4 records in that list in future .