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.

0 |

11/17/2009 4:14:06 PM

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") -- David Biddulph "Angela" <Angela@discussions.microsoft.com> wrote in message news:BB1B7058-C858-4DA2-B032-D34E7CC75628@microsoft.com... >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. > >

0 |

11/17/2009 4:32:17 PM