The problem is with your data in the cells and not the formula. Make sure
you change the ranges of the data to match you worksheet. The best way of
debugging a formula proble is use the evaluate formula tool

Menu Tools - formula auditing - evaluate formula

As you evaluate the formula you should see which item causes the #value to
appear. You may have to run the tool a few times until you see where the
problem is located.


"Shiva" wrote:

Hi Joel,
Thanks for your support. But, I get an error when build same farmula. I get
a text 'Value' in the cell.
Can you help me in finding no of items for the quarter and sum of the cost
for the same items for the quarter?

"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.