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