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,"<>")
Lycias Yes classfied as very high in column AF and they have a programme in column AG (that is its row in AG is not blank. Thanks,
- Untested, only the beginning and end of the columns have to be adjusted.
=SUMIF(A1:A50, „Mosambik“, C1:C50)
If you find one of the solutions helpful, please mark it as "Best Answer" and as Like (click thumbs up), it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
