Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding percentages 0
Hi all.
I have a sheet where H15:H71 are filled with percentages. What I'd like is to calculate the whole area above without counting any cells containing zero. Can anyone help please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding percentages 0
Do you mean you want to count the cells which are not equal to zero, or
add them up? Try one of these: =COUNTIF(H15:H71,"<"&0) =SUMIF(H15:H71,"<"&0,H15:H71) Hope this helps. Pete Caractus wrote: Hi all. I have a sheet where H15:H71 are filled with percentages. What I'd like is to calculate the whole area above without counting any cells containing zero. Can anyone help please? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding percentages 0
I want to count the cells which are not equal to zero but the thing is
they're all percentages so an average would probably be more accurate, otherwise the total will read as over 100% |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding percentages 0
Thanks for the reply Pete.
I want to count the cells which are not equal to zero but they are all percentages, so an average would probably be more accurate. Otherwise the total would be over 100%. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding percentages 0
=AVERAGE(IF(H15:H71<0,H15:H71))
which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Caractus" wrote in message oups.com... Thanks for the reply Pete. I want to count the cells which are not equal to zero but they are all percentages, so an average would probably be more accurate. Otherwise the total would be over 100%. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding percentages 0
Perfect. Thanks a lot!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frogs in the pond - Display percentages not numbers | Charts and Charting in Excel | |||
building YTD figures by adding to a previous months total | Excel Discussion (Misc queries) | |||
What format do I use to mail merge percentages? | Excel Discussion (Misc queries) | |||
Adding Percentages | Excel Discussion (Misc queries) | |||
Adding percentages in a column and automatic formating of contents | Excel Worksheet Functions |