=SUMPRODUCT(--('Project Master'!G82:G369="Gap"),
--('Project Master'!F82:F369="SME"))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MMcQ" wrote in message
...
Sorry I'm back with another question, and not sure if it will be picked up
at
the end of my last string, so I'm adding this in as a new question - sorry
I'm a rookie to the Discussion Forum....

I'm working on a spreadsheet and thought the same forumla would work (it
worked for preivous formula when numbers where involved). This time I'm
checking two seprate column and want to count the number of results if the
value in one field is Gap and the value in the other column is SME or
variables as I define.

Would you take a quick look at this formula and see where I'm going
wrong -
sorry!

=SUMPRODUCT(--('Project Master'!G82:G369=Gap),--('Project
Master'!F82:F369=SME))