Countif based on month

[bnwash]

With help from the forum the amounts are calculated in the attached worksheet but I am doing something wrong with the count situation
again assistance appreciated

[bnwash]

Just noticed that the amount cols are also incorrect - altering the date to other than the 1st makes the amount vanish so that formula is incorrect also

again assistance apprecialed

[FDibbins]

I think you need this, not just count()...
=COUNTIFS(Entry!$C$11:$C$133,$B8,Entry!$A$11:$A$133,Summary!F$6)

[bnwash]

Thanks I have tried the formula but it does not appear to work

[benishiryo]

hi bnwash. try this for E8:
=COUNTIFS(Entry!$C:$C,$B8,Entry!$A:$A,">="&F$6,Entry!$A:$A,"<="&EOMONTH(F$6,0))

this for F8:
=SUMIFS(Entry!$E:$E,Entry!$C:$C,$B8,Entry!$A:$A,">="&F$6,Entry!$A:$A,"<="&EOMONTH(F$6,0))

[FDibbins]

Thanks I have tried the formula but it does not appear to work

what did you get and what did you expect? I got an answer of 1 in E8, and checking Entry sheet, that is what you have there too

[bnwash]

Thanks appreciate your assistance