Formula Problem in Excel 2007

  • Thread starter Thread starter Tim Weaver
  • Start date Start date
T

Tim Weaver

I am ~very~ new to using Excel. From what I can understand the COUNTIFS
function should work. My impression is that it's telling me I have a data
type mismatch. The formula cell with the error is AI24. Any help would be
appreciated.

Here's the file: http://home.comcast.net/~tmw99999/Employmenttemp.xlsx

(All I'm doing here is tracking the days I've worked and days I haven't
worked.)
--
Tim Weaver

I know you believe you understand what you think I said,
but I'm not sure you realize that what you heard is not
what I meant.
 
My guess is that it is because the ranges are not the same size, try

=COUNTIFS(C5:AG5,1,C6:AG6,1)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top