Posted to microsoft.public.excel.misc

external usenet poster

Posts: 177

condense formula that sums 4 adjacent columns

Any suggestions on how to make this shorter?

=INDEX(OFA!$DM$4:$DM$6000,MATCH(A2,OFA!$D$4:$D$600 0,0),1)+INDEX(OFA!$DN$4:$DN$6000,MATCH(A2,OFA!$D$4 :$D$6000,0),1)+INDEX(OFA!$DO$4:$DO$6000,MATCH(A2,O FA!$D$4:$D$6000,0),1)+INDEX(OFA!$DP$4:$DP$6000,MAT CH(A2,OFA!$D$4:$D$6000,0),1)

many thanks!

SteveC

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
Formula to match 7 columns of non adjacent data	[email protected]	Excel Worksheet Functions	0	January 10th 08 11:11 PM
Conditional sums for adjacent cells	Eric	Excel Worksheet Functions	6	January 29th 07 09:00 PM
How do I condense 3 columns into 1 in Excel?	Niki	Excel Worksheet Functions	1	April 13th 06 06:32 PM
Condense formula	Derek Y via OfficeKB.com	Excel Worksheet Functions	9	November 18th 05 03:00 AM
Help to condense a formula	GerryK	Excel Worksheet Functions	1	June 29th 05 08:19 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us