Posted to microsoft.public.excel.programming

Chad[_12_] Chad[_12_] is offline

external usenet poster

Posts: 49

Shorten multiple sumifs

Hi

Would anyone know of a way to shorten multiple sumifs. This formula
is getting very long.

Sumif(A2,Sheet1!B2:B10,Sheet1!D2:D10)+Sumif(A2,She et1!B2:B10,Sheet1!
F2:F10)+Sumif(A2,Sheet1!B2:B10,Sheet1!G2:G10)etc.

The problem is the design of the sheet where the summed data is not in
adjacent columns. Is there a custom function to shorten this? Thanks
in advance.

Chad

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
sumifs multiple columns help	duketter	Excel Worksheet Functions	2	May 8th 10 08:44 AM
using sumifs with multiple criteria?	Celia	Excel Discussion (Misc queries)	3	April 8th 09 02:14 AM
Multiple Sumifs	Emeryville John	Excel Worksheet Functions	1	September 19th 08 10:12 PM
SumifS Multiple Sum Ranges	dee	Excel Worksheet Functions	2	May 23rd 07 08:42 PM
SumifS Multiple Sum Ranges	Harlan Grove[_2_]	Excel Worksheet Functions	0	May 23rd 07 08:40 PM

All times are GMT +1. The time now is 07:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us