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
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
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
=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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks