Posted to microsoft.public.excel.misc

external usenet poster

Posts: 61

Sum If Visible

I have a formula in a cell to sum based on different critieria....
=SUMPRODUCT(--($B$7:$B$399="F"),--(AD7:AD399<200),AD7:AD399) now I've added
a filter and only want it to sum the cells that are visible (b/c the filter
only makes visible the certain cells)...is there a way to do this?

Thanks!

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	assaf1978	Excel Discussion (Misc queries)	1	November 13th 08 08:32 AM
Values are not visible	Milan	Excel Discussion (Misc queries)	2	March 17th 08 02:41 PM
sum visible row only	Qaspec	Excel Discussion (Misc queries)	2	October 9th 07 04:33 PM
Countif visible	Sean	Excel Discussion (Misc queries)	4	August 27th 06 12:03 AM
Autoshapes not visible on spreadsheet but visible in print preview	John	Excel Discussion (Misc queries)	3	February 11th 05 10:23 PM

All times are GMT +1. The time now is 10:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us