Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 38

sumproduct and visible cells

Is there a way to make sumproduct or the new sumifs in Excel 2007 work only
with the visible cells in the specified range? I want to be able to sum the
data on a worksheet after applying a filter to the data range. I know
nothing of VBA and am relatively new to Excel.

Thanks,
Lee

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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 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
Visible cells	Melissa	Excel Worksheet Functions	0	February 15th 05 07:23 PM
SUMPRODUCT TO CALCULATE VISIBLE CELLS ONLY	Lisa	Excel Worksheet Functions	4	January 11th 05 12:58 PM

All times are GMT +1. The time now is 06:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us