You can only use the entire column if you're using xl2007.

Chad Portman wrote:

Tried this and I get a NUM error. the formula I am using is:

=SUMPRODUCT(--(Sheet1!E:E="Wide"),--(Sheet1!D:D="Black"))

"FSt1" wrote:

hi
countif wont do that but sumproduct will.
=sumproduct((A:A = "somecondition")*(B:B="someothercondition"))

read up on sumproduct and see this site....
http://www.contextures.com/xlFunctio...tml#SumProduct

regards
FSt1

"Chad Portman" wrote:

I have a list of data in coloumns A and B. I need to write a countif style
formula for if column A has one set of data in it while at the same time
column B has another set of data. So it should only count if the conditions
for column A and the conditions in column B are met.

--

Dave Peterson