Thanks, I've tried this formula but it doesn't give me the right answer.
For example, I should get an answer of 3 but it gives me 10. If I change
either parameter to 1, I get the proper count but when it's together, I get
the wrong answer. Is there any way to debug? Suggestions?

"excelent" wrote in message
...
=sumproduct((a1:a1000="X")*(b1:b1000250))
change range to fit


"Kent McPherson" skrev:

I have data with multiple columns. I want to count all items in column A
=
"X" and with column B 250. I know how to do either condition but I
need
to join the two. Any help would be appreciated. Thanks!