Multiple conditions on a countif
 

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

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

www.OfficeArticles.com


"Mr Mike" wrote in message
...
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

Here you go:

=SUMPRODUCT((A1:A10=1)*(C1:C100))

adjust ranges as necessary.

"Mr Mike" wrote in message
...
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

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

--
Regards
Roger Govier
"Mr Mike" wrote in message
...
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

Hi,

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

SUM(IF((B5:B10=1)*(D5:D100),1,0),C5:C10)

Regards,

Ashish Mathur

"Mr Mike" wrote:

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

Multiple conditions on a countif
 

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

www.OfficeArticles.com


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


--
tlosgyl3
------------------------------------------------------------------------
tlosgyl3's Profile: http://www.excelforum.com/member.php...o&userid=28074
View this thread: http://www.excelforum.com/showthread...hreadid=450641