I'm trying to get a count of how many times a value appears in either of 2
columns vs. a set column. In plain English, how many times does Bonds appear
as the value in either Content 1 or Content 2 when the Office is ATL. I
thought I had it using the conditional sum wizard and converting that to a
COUNT, but it's only calculating true/false. I also tried SUMPRODUCT, but
that gave me a #VALUE error. Here is the COUNT formula I had:

=COUNT(IF('Master List'!$D$3:$D$3000="ATL",IF('Master
List'!$H$3:$H$3000="Bonds",IF('Master List'!$I$3:$I$3000="Bonds",1,0),0),0))

I'm sure I've only been a keystroke or two away from getting this right, but
I just can't figure it out.

Thanks for your help.

How do I return the

How can I write this to return the total