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 are not blank in column AG (that is they have at least a programme listed in that column).
Please see attached file.
Thanks
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,"<>")
3 Replies
- 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)
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,"<>")
