Using CountIf or similar with 2 conditions

[Nicky C]

Hi, I'm sorry to have to post a fairly basic question, unfortunately I need some help and I don't have time to search the forums.
On the same worksheet, I need to insert a calculation which works out, if, the total of rows which have E column containing the text 'EH' AND have I column containing the text 'Outstanding' - any help much appreciated - thank you

 

[MrKowz]

Try:

=SUMPRODUCT(--(ISNUMBER(SEARCH("EH",E1:E100))),--(ISNUMBER(SEARCH("Outstanding",I1:I100))))

or if EH and Outstanding are the actual cell values:

Excel 2003 or older:
=SUMPRODUCT(--(E1:E100="EH"),--(I1:I100="Oustanding"))

Excel 2007 or newer:
=COUNTIFS(E:E,"EH",I:I,"Outstanding")

 

[Nicky C]

Genius - thank you very very much!