Percentage of filled cells

Carla Bradley

Posts: n/a

Percentage of filled cells

I have a client with Excel 2002. He wants to calculate a row of data and the
result would be the percentage of fields with a value in them. So for example
if I asked it to check 20 cells and 10 had numbers in them, I'd get a result
of 50%. Anyone know of a way of doing this?

Thanks.
Carla Bradley

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
How do I sum up values only in cells that are color filled?	TryingExcel	Excel Worksheet Functions	7	April 12th 09 03:34 PM
To safety merge cells without data destroyed, and smart unmerge!	Kevin	Excel Discussion (Misc queries)	0	December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet	Kevin	Excel Discussion (Misc queries)	0	December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text	Kevin	Excel Discussion (Misc queries)	0	December 30th 04 06:55 AM
calculate percentage of two cells	Suzie	Excel Worksheet Functions	4	December 3rd 04 05:27 PM

All times are GMT +1. The time now is 01:38 PM.

Menu

About Us