Thread: quarter report
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
shiva shiva is offline
external usenet poster
 
Posts: 12
Default quarter report

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.