View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default How can i sum up numbers which are counted on a date.

Need to see the structure of your data, but......
This will count the number of times "January" occurs in column A.
=COUNTIF(A:A,"January")

This will sum the data in column B where column A equals "January".
=SUMIF(A:A,"January",B:B)

Tweak as needed.
Terry wrote:
Hi, I am working with a sheet that has data based on the month and number of
items counted. I want to know the number of items counted per month, how can
i make a formula for this.