I am trying to use the sumproduct equation and I am get a VALUE
response.

I am trying to sum up information that is presented in columns F
through W, with each column represent a certain weekday. I then have
included certain categories in column E (rows 8 through 90) for which I
will want to sum into another spreadsheet by category and date. It
looks some thing like this:

2/24 3/3 3/10 3/17
Non-Affiliate
Energy Energy 100 250 175 800
Water Energy 300 300 275 900
O&M Other 25 10 20 20

Affiliate
Fuel Fuel 250 250 250 900
O&M Fuel 400 100 250 250
Hydro Other 10 10 15 15

So, I've set up my formula as follows:

=SUMPRODUCT(--('Corporate (2)'!$F$6:$W$90='Final Corp Template-we
24-Feb'!F$6),-('Corporate (2)'!$E$6:$E$90='Final Corp Template-we
24-Feb'!$E13),('Corporate (2)'!F$6:F$90))

Where 'Corporate (2)' is the spreadsheet with the data and 'Final Corp
Template-we 24-Feb' is where I would like the results placed.

I don't know if I am having problems as a result of data ranges, but I
can't seem to see how to get this to work.

The desired result would be as follows for 2/24:

Non-Affiliate Energy - 400
Non-Affiliate Other - 25
Affiliate Fuel - 650
Affiliate Other - 10

Any help will be appreciated.


--
jcastellano
------------------------------------------------------------------------
jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986
View this thread: http://www.excelforum.com/showthread...hreadid=521899