Countif, Sumif, If - help!

A

Angel160

Alex,

This returns #Value. I don't think I need to sum the number of bul
deals - what I am looking to do is count how many of the bulk deals w
have done are over £10,000
 
A

Alex Delamain

Oh dear! I used the following data to model your query:

Bulk £4,000
Bulk £60,000
Non Bulk £1,000
£15,000
Bulk £10,050

=SUMPRODUCT((A1:A101="Bulk")*(B1:B101>10000))

returned an answer of 2 for the above data - ie row 2 and 5 are Bul
and over £10,000. Can I suggest you cut and paste the formula to avoi
any typos, or post a sample of your data so we can try to work out wha
is wrong
 
Top