Forum Discussion
Solved
Excel formula with multiple criteria
Hi, Hoping you are doing well. I would like to calculate the sum of values in column H for each of the countries pulling all rows for Mozambique, that are classified in column AH as Very High and ar...
Do you mean column AF instead of AH? Column AH is blank. If so:
=SUMIFS(H2:H61,A2:A61,"Mozambique",AF2:AF61,"Very High",AG2:AG61,"<>")
Do you mean column AF instead of AH? Column AH is blank. If so:
=SUMIFS(H2:H61,A2:A61,"Mozambique",AF2:AF61,"Very High",AG2:AG61,"<>")