SUMPRODUCT statistics

[umpexec]

Hi All,

On Sheet1 I have 2 cells one has the date 1-mar-09 and the other has 7-mar-09. I need to find this range on Sheet2 which has all the dates for the year in ColumnA and then total the amounts found in Sheet2!ColumnB for the specified date range. Is this possible without VB?

Thanks,
Leanne

 

[Mr. Walnuts]

wow...
that was ALOT easier than the INDEX I was doing.
what's the reason for the "--" in there?

 

[Aladin Akyurek]

It works! Thanks for the help.

You are welcome.

What are the dashes for?
Leanne

A few links on the subject:

http://www.mrexcel.com/forum/showthread.php?t=202204

http://www.mrexcel.com/forum/showthread.php?t=70547

 

[Mr. Walnuts]

Wow...
You even write smart.

*edit* that was a great explanation of that usage.