REVscene Automotive Forum - Excel help! COUNTIFS formula

REVscene Automotive Forum (https://www.revscene.net/forums/)

- Gaming, Computer Tech & Electronics (https://www.revscene.net/forums/gaming-computer-tech-electronics_32/)

- - Excel help! COUNTIFS formula (https://www.revscene.net/forums/700507-excel-help-countifs-formula.html)

Excel help! COUNTIFS formula

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!

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

Quote:

Originally Posted by Spoon (Post 8575244)

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.