Been banging my head on the keyboard for last 2 hours trying to figure out how I used to sum multiple criteria within a single range when using {"text","text"}, but not working.
This formula only gives me the 10-1result, and I need to add for columns up each for the day, with 16 different criteria??
Also, I don't really want a 15 line formula for only adding 4 criteria up over 4 columns. Is there a way to sum all 4 periods. P1,P2,P3,P4, only adding the 10-1, 10-2,10-3 criteria? 10-1,10-2 etc cells are dropdown lists.
=SUMIF(B3:B13,{"10-1","10-2"},C3:C13)
Sorry, my small file wouldn't upload?
name P-1 Hrs P-2 Hrs P-3 Hrs P-4 Hrs
a 10-1 8.1 13-2 1.0 NA NA
b 10-1 8.1 NA NA NA
y 10-1 8.0 NA NA NA
d 10-3 8.0 NA NA NA
r 10-1 7.5 NA NA NA
f 10-1 8.0 NA NA NA
g 10-2 9.0 NA NA NA
gh 10-1 10.0 NA NA NA
i 10-1 11.0 NA NA NA
j 10-2 14.0 NA NA NA
k 10-1 13.0 NA NA NA
Bookmarks