Posted to microsoft.public.excel.worksheet.functions

pwz

Posts: n/a

sumif only for unhidden rows

How to build a conditional sum formula for unhidden rows only (other rows
are hidden manually or by auto-filter)? Thanks in advance!

Regards,
Pat

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 you ignore hidden rows in a SUMIF() function?	Gerry	Excel Worksheet Functions	12	October 8th 09 05:20 PM
How to swap rows and columns?	[email protected]	Excel Discussion (Misc queries)	5	September 21st 05 08:07 AM
Automatically inserting rows	ausdiver99	Excel Worksheet Functions	1	June 2nd 05 02:15 PM
Hiding Rows if the linked rows are blank	KG	Excel Discussion (Misc queries)	9	May 18th 05 02:32 AM
flexible paste rows function that inserts the right number of rows	marika1981	Excel Discussion (Misc queries)	1	February 18th 05 02:40 AM

All times are GMT +1. The time now is 04:44 PM.

About Us

"It's about Microsoft Excel"