Countifs on a range

[Corleone]

I would like for run a formula which counts all cells with the word UPDATE in it where column A = A
The formula below works for one column

=COUNTIFS(A3:A19,"A",$B$3:$B$19,"UPDATE")

However, i want to do it for the full range - I tried the formula below but just get a #value message

=COUNTIFS(A3:A19,"A",$B$3:$H$19,"UPDATE")

any help appreciated

thanks

 

[Fluff]

How about

=SUMPRODUCT((A3:A19="A")*($B$3:$H$19="UPDATE"))

 

[Corleone]

Splendid Sire

many thanks

 

[Fluff]

You're welcome & thanks for the feedback.