Countif array formula

G

Guest

I have the following formula to count values greater than zero.

=COUNTIF('Product Sales'!$H$4:$H$1000, ">" & 0)

I want to change it so that if the sum of the range in a row is greater than
zero.

=COUNTIF(sum('Product Sales'!$H$4:$S$1000), ">" & 0)

I know this is not correct, but what do I need to do?

Bruce
 
B

Bob Phillips

=SUM(IF('Product Sales'!$H$4:$S$1000>0,'Product Sales'!$H$4:$S$1000))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Can you use an INDEX array in a COUNTIF formula ? 1
Two Criteria COUNTIF 7
Scrabble Value calculation for Welsh words 0
Countif, plus ? 8
How can I use the * wildcard in an array formula 4
Countif and values greater than zero for a named range 1
COUNTIF for 2 columns 6

Top