countifs with OR statement

[Mattlake]

Hi

I am hoping this is an easy one.

I have a spreadsheet with many fields so need to have a total page.

I need a sum that counts if there is an x in either columns F or H of a sheet called North and South as long as column E of the same sheet contains the text that is in column C on the total page
I can get the formula

=COUNTIFS('North and South'!E:E,C5,'North and South'!F:F,"X")

but cannot get column H to work as well

any help would be appreciated

Regards
Matthew

 

[DanteAmor]

Try:

=COUNTIFS('North and South'!E:E,C5,'North and South'!F:F,"X")+
COUNTIFS('North and South'!E:E,C5,'North and South'!F:F,"<>X",'North and South'!G:G,"X")

 

[Mattlake]

perfect thank you