Multiple conditions on a countif

[Guest]

Hello, Using the grid below, I would like to create a count of all stores in
Rgn 1 that have sales greater than zero. Thanks for your help!

Region Store Sales
1 A 5
2 B 6
1 C 7
2 D 0
1 E 2
2 F 8

 

[Anne Troy]

Try this, Mike:
http://www.officearticles.com/excel/count_using_multiple_criteria_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com

 

[Dave R.]

Here you go:

=SUMPRODUCT((A1:A10=1)*(C1:C10>0))

adjust ranges as necessary.

 

[Roger Govier]

=SUMPRODUCT(--($A$2:$A$100=1),--($C$2:$C$100>0))
Change ranges to suit

 

[Guest]

Hi,

Try the following array formula (Ctrl+Shift+Enter)

SUM(IF((B5:B10=1)*(D510>0),1,0),C5:C10)

Regards,

Ashish Mathur

 

[tlosgyl3]

Try this, Mike:
http://www.officearticles.com/excel/...ft_excel.h tm
*******************
~Anne Troy

www.OfficeArticles.com


Many thanks Anne - works a trea
http://www.excelforum.com/images/smilies/smile.gif
: