Posted to microsoft.public.excel.misc

external usenet poster

Posts: 4

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Frogs in the pond - Display percentages not numbers	Oliver J.	Charts and Charting in Excel	6	October 6th 06 03:21 PM
building YTD figures by adding to a previous months total	axialtilt	Excel Discussion (Misc queries)	7	July 24th 06 04:07 PM
What format do I use to mail merge percentages?	Lily1521	Excel Discussion (Misc queries)	1	April 17th 06 02:38 PM
Adding Percentages	Homer J	Excel Discussion (Misc queries)	0	August 11th 05 09:27 AM
Adding percentages in a column and automatic formating of contents	FTP	Excel Worksheet Functions	3	May 17th 05 06:14 PM

All times are GMT +1. The time now is 03:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us