Thread: How can i sum up numbers which are counted on a date.
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
terry terry is offline
external usenet poster
  
Posts: 193
Default How can i sum up numbers which are counted on a date.
I THINK THE CRITERIA PART IS MY PROBLEM !!!
=SUMIF('Data Input'!$A$5:A1294,"(--('Data
Input'!$A$5:$A$1294=DATE(2007,1,1)),--('Data
Input'!$A$5:$A$1294<=DATE(2007,1,30)))",'Data Input'!$B$5:B1294)

"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.
Reply With QuoteReply With Quote