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