Multiple conditions on a countif

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

www.OfficeArticles.com


"Mr Mike" <[email protected]> wrote in message
news:[email protected]...
> 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:C10>0))

adjust ranges as necessary.

"Mr Mike" <[email protected]> wrote in message
news:[email protected]...
> 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$100>0))
Change ranges to suit

--
Regards
Roger Govier
"Mr Mike" <[email protected]> wrote in message
news:[email protected]...
> 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:D10>0),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

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

www.OfficeArticles.com


"Mr Mike" <[email protected]> wrote in message
news:[email protected]...
> 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:C10>0))

adjust ranges as necessary.

"Mr Mike" <[email protected]> wrote in message
news:[email protected]...
> 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$100>0))
Change ranges to suit

--
Regards
Roger Govier
"Mr Mike" <[email protected]> wrote in message
news:[email protected]...
> 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:D10>0),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

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/...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Mr Mike" <[email protected]> wrote in message
news:[email protected]...
> 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:C10>0))

adjust ranges as necessary.

"Mr Mike" <[email protected]> wrote in message
news:[email protected]...
> 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$100>0))
Change ranges to suit

--
Regards
Roger Govier
"Mr Mike" <[email protected]> wrote in message
news:[email protected]...
> 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:D10>0),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