Mark,

Use the following formula

=SUM(IF(D9:D11&A9:A11=D11&A9,C9:C11,0))

and press cntrl+shift+enter instead of just enter. This assumes your data
starts in cell A8 (sold)
--
http://www.ExcelHelp.us

Call me at
1-888-MY-ETHER ext. 01781474



"Mark Allen" wrote:

I have the following spread sheet that I need to calculate the value of if "Y"

A B C D
Sold Product Value Date
Y Hardware $20.00 Jan-09
Y Software $50.00 Feb-09
N Hardware $50.00 Jan-09

Ok, so I want to know the "value" of the Hardware items sold "Y" in Jan-09.

Do I use SUMPRODUCT

Hope some one can help please.

Regards

Mark