Hi

Try something like this:
=SUMPRODUCT((A2:A1000="direct mail")*(B2:B1000="January"))

Hope this helps.
Andy.

"SkyGanz" wrote in message
...
I am trying to "count if" across two columns. i.e Column A has categories:
direct mail, ads, tradeshows; and column B has months: January, Feb, Mar.
etc. I need the formula that will show me a count of all "direct mail" in
"January". I can't get the "countif" formula to do it, and a pivot table
is
not working either. Any suggestions? Any formulas to try