Using the "COUNTIFS" function in Excel, I am trying to tabulate a total sum (of counts) across a number of ranges / criteria. The formula is working properly until I ask Excel to count the number of dates marked in a column as "1/0/1900." Everything leading up to this part of the formula works (I broke down into parts to prove it). Because I am not referencing the "1/0/1900" date correctly (I'm assuming), my total keeps returning back to 0 - thus, negating the rest of the "good" part of the formula. Net / net: I need to count the "1/0/1900" dates, but don't know how. Thx. - Jamie
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!