Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default sumproduct?

Good afternoon:

I have a list of data (see below)

LTL 4000-403000-430015-716 2005 3 $8.81
LTL 4000-403000-430015-403 2003 11 $15.59
SMPK 4000-403000-430015-403 2005 6 $17.80
SMPK 4000-403000-430015-403 2005 9 $27.28
SMPK 4000-403000-430015-716 2005 6 $32.12
LTL 4000-403000-430015-404 2004 6 $33.00
SMPK 4000-403000-430015-716 2005 5 $33.74
LTL 4000-403000-430015-403 2003 10 $43.00



In a separate portion of the spreadsheet, I would like to have 4 cells
filled with:
- LTL
- 4000-403000-430015-716
- 2005
- 3

And I would like excel to return the value $8,81 in a fifth cell... What is
the formula I need to use to obtain the value in the 5th cell based on the
value I have in 4 different cells

What if There are several rows with the same values (LTL,
4000-403000-430015-716, 2005, 3)... What would be the sumproduct statement
like?

Thanks


 
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
Adding "OR" to a Sumproduct Formula Duke Carey Excel Worksheet Functions 0 March 21st 06 06:41 PM
Need help with sumproduct and dynamic ranges Bill_S Excel Worksheet Functions 2 March 19th 06 01:19 AM
sumproduct causing memory errors? dave Excel Worksheet Functions 1 March 3rd 05 09:31 AM
Sumproduct function not working Scott Summerlin Excel Worksheet Functions 12 December 4th 04 05:15 AM
adding two sumproduct formulas together ski2004_2005 Excel Worksheet Functions 1 November 12th 04 09:08 PM


All times are GMT +1. The time now is 12:03 AM.

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"