LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default help on sumproduct of named ranges

hello,

please help me to accomplish a simple formula...

i have many different named range, to simplify the data here goes below...

my range name for search criteria:
MRO <A2:A200
MRO1 <B2:B200

my range name for summing result something like a calculator
MRO2 <C2:C200
MRO3 <D3:D200
MRO4 <E3:E200

In a formula like this, its okey
=sumproduct(--(MRO0),--(MRO12),MRO2)

then, if i use a cell say A1, then i place the range name like "MRO2" or
"MRO3", or "MRO4" ---- one at a time...

then,how to write it down in a formula something like this:
=sumproduct(--(MRO0),--(MRO12),"&A1")

i need to save space so i may prefer to use A1 as the holder for my result
range.

i hope it may make sense....trying to gain more simplicity.

thanks and regards,
driller
--
*****
birds of the same feather flock together..

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Using named 3-D ranges Nick S. Excel Discussion (Misc queries) 1 March 22nd 07 11:26 AM
Sumproduct using named ranges and multiple criteria A.Gates Excel Discussion (Misc queries) 5 January 26th 07 11:41 PM
Named Ranges in VBA Bruce Excel Discussion (Misc queries) 1 June 17th 05 03:35 AM
3D Named Ranges David Excel Worksheet Functions 0 June 7th 05 05:22 PM
Like 123, allow named ranges, and print named ranges WP Excel Discussion (Misc queries) 1 April 8th 05 06:07 PM


All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"