Posted to microsoft.public.excel.worksheet.functions

Jaan

Posts: n/a

too long sumif help

Hi
Could I create short formula

=SUMIF(A1:E1;G$4;A2:E2)+SUMIF(A3:E3;G$4;A4:E4)+SUM IF(A5:E5;G$4;A6:E6)+SUMIF(A7:E7;G$4;A8:E8)+SUMIF(A 9:E9;G$4;A10:E10)+SUMIF(A11:E11;G$4;A12:E12)+SUMIF (A13:E13;G$4;A14:E14)..............+SUMIF(A201:E20 1;G$4;A202:E202)

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
More than 3 conditional formats?	Ltat42a	Excel Discussion (Misc queries)	12	January 6th 06 11:26 AM
Format cells with a formula (7 conditions).	danindenver	Excel Discussion (Misc queries)	3	January 2nd 06 02:40 PM
Date & Time	mully	New Users to Excel	4	May 23rd 05 11:56 AM
Automatically up date time in a cell	Mark	Excel Discussion (Misc queries)	5	May 12th 05 12:26 AM
clock	Wildman	Excel Worksheet Functions	2	April 26th 05 10:31 AM

All times are GMT +1. The time now is 08:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us