Countif and values greater than zero for a named range

A

Angela

I have a workbook with 30+ worksheets. For each of the sheets, there is a
cell (F51) that is part of a named range (PPG). On Sheet 1, cell c9, I want
to sum the range (PPG) and then divide by ONLY the number of cells on the
other sheets (F51) that are greater than 0.

I am able to sum and then divide by count (=sum(PPG)/Count(PPG) but I cannot
seem to get it to only count the cells that are greater than zero.

When I attempt to use suggestions from other posts:
(=sum(PPG)/COUNTIF(PPG)>0) I get error.

Any help is appreciated.
 
D

David Biddulph

If you need Excel help on how the COUNTIF function works, look up COUNTIF in
Excel help.

I guess that you wanted
=SUM(PPG)/COUNTIF(PPG,">0")
 

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

AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
COUNTIF for 2 columns 6
Countif array formula 1
Combine Sumif and Countif 3
Countif a corresponding value is not equal to zero or blank 1
Two Criteria COUNTIF 7
sumif across multiple sheets in excel 2007 based on a condition 7
SUMIFS Between dates that are greater than zero 1

Top