adding rows based on dates

[StartingOut]

Hi all, I have a workbook with 3 tabs, on sheet1 I have a Date picker form to enter the date in each cell in column A, in column B I have serial numbers (but it doesn’t really matter I could have bananas in column B) The dates selected in column A will represent the days of the month like column A row 1, 2, 3, 4 could have May 2<SUP>nd</SUP> as the date and row 5. 6. 7 could have May 3<SUP>rd</SUP> as the date. On sheet 2, I have a summary of all the days of the month in Column B (1<SUP>st</SUP>, 2<SUP>nd</SUP>, 3<SUP>rd</SUP> etc). What I need is code that will search Sheet1 Column A and find all the dates for the first of the month and then add how many there are and put that total in sheet2 column C row 2 then find all the dates for the next day of the month and put that in column C row 3 all the way through to the end of the month.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[AlphaFrog]

You could use the SUMIF function...

Sheet2 cell C2
=SUMIF(Sheet1!A:A, B2, Sheet1!B:B)

B2 has to be a date e.g. May, 1, 2011. You could have the dates formatted to just display as a day of the month.

 

[StartingOut]

thank you, it turns out I needed the COUNTIF not the SUMIF but you pointed me in the right direction when I was lost. thanks for the help its appriciated.

 

[AlphaFrog]

You're welcome. I'm glad you were able to solve it.