Excel formula with multiple criteria

[Lycias]

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

[#2 · Accepted solution]

@Lycias 

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]

@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,

[#4]

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)