Posted to microsoft.public.excel.misc

DianeG

external usenet poster

Posts: 59

Sum visible cells only

Hi

Is there a way to sum visible cells only without using a pivot table? Some
values are sitting in hidden columns and they still add up, I'd like them to
be ignored

Thanks

Diane

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
Sum Visible Cells	Julie	Excel Worksheet Functions	5	February 26th 08 12:31 AM
Sum of visible cells only	Stgeorge	Excel Worksheet Functions	11	August 23rd 06 04:58 PM
sum only visible cells	hommer	Excel Worksheet Functions	5	May 11th 06 11:39 PM
Visible Cells Only!	Don	Excel Worksheet Functions	2	May 2nd 05 09:48 PM
can i sum up only visible cells?	Wink	Excel Worksheet Functions	2	April 1st 05 07:10 PM

All times are GMT +1. The time now is 12:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us