Count the occurence of more than one condition

  • Thread starter Thread starter wutang1105
  • Start date Start date
W

wutang1105

Got this function from Excel Help but it gives me #Value error. Ca
anyone help?





=SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))

Number of invoices for Buchanan with a value less than 9,000. (1
 
It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Receiving #VALUE! when using examples from Microsoft Excel, why? 2
Excell - two conditions count if factors are true when negative nu 2
Conditional Formatting Confusion... 1
formula for counting the occurence of more than one condition 2
Count range of data 2
Count...Sum...Faster...improvemens...; Have a good end of YEAR 2
Count a number in a range with cells containing more than one numb 12
Conditional Formatting Driving Me Crazy 1

Back
Top