Formula needed for countif and sumif based on date format 12/23/13, etc.

[excelteam777]

Need 2 formulas; countif and sumif.

Dealing with 2 sheets, for example sheet1 and sheet2

First the countif, lets say I am trying to count the number of times data is entered into C6:C1005 based on the month from B5:B1005
using the month of January in this case 01/20/13 as format.

sheet1

B6:B1005 = date in this format 12/23/13 is entered
C6:C1005 = the column to count based on the month from B5:B1005

sheet2

D4 = Jan (where formula needs to be)

Now the sumif, same scenario but now I am trying to sum only the cells between G6:G1005 based on the month from B5:B1005
using the month of January in this case 01/20/13 as format.

sheet1

B6:B1005 = date in this format 12/23/13 is entered
G6:G1005 = the column to count based on the month from B5:B1005

sheet2

E4 = Jan (where formula needs to be)

[FDibbins]

Take a look at using countifS() and sumifS() for this.

See what you come up with, give me a shout and provide a sample workbook if you still have a problem

[Tony Valko]

Are the dates all within the same year?

[Tony Valko]

Is this a duplicate post?

http://www.excelforum.com/excel-form...-attached.html