=SumProduct(--(A1:A100 = datevalue("4-1-08")),--(A1:A100 <=
datevalue("6-30-08")),--(B1:B100="Pen"),C1:C100)

"Shiva" wrote:

Hi,
Can any one help me to solve my problem. I have my business data as following

Date Product Cost
2-4-08 Pen 3.0
3-6-08 Pencil 1.0
4-5-08 Eraser 0.5

Now, I want to count products individually on quarterly basis from April to
July etc and find the total sum of the business for the quarter.