Excel help! COUNTIFS formula

[Spoon]

Hopefully someone good with excel can help me out with my formula. It was working when I originally set it up but for some reason it doesn't work anymore.

Here's my original formula:
=COUNTIFS(alliance!F:F,">=1/10/2014",alliance!F:F,"<=31/10/2014")

What I'm trying to do is setup a count for a worksheet called "alliance". The count is for the whole F column and I only want the count for a certain date range (for this example, it was for the month of October).

Can someone let me know where I screwed up?

Thanks!

[GGnoRE]

That formula is correct. Check your F column in alliance worksheet or perhaps its a typo.

[DaFonz]

Originally Posted by Spoon

Hopefully someone good with excel can help me out with my formula. It was working when I originally set it up but for some reason it doesn't work anymore.

Here's my original formula:
=COUNTIFS(alliance!F:F,">=1/10/2014",alliance!F:F,"<=31/10/2014")

What I'm trying to do is setup a count for a worksheet called "alliance". The count is for the whole F column and I only want the count for a certain date range (for this example, it was for the month of October).

Can someone let me know where I screwed up?

Thanks!

Your date formats are likely conflicting. it's also generally a bad idea to put dates into formulas like that because things break depending on what localization settings are on a computer.

Change your formula to

=COUNTIFS(alliance!F:F,">="&C1,alliance!F:F,"<="&D 1)

And put the start and end dates in C1 and D1. You'll have a much easier time tracking down problems is there are any.