Forum Discussion
Excel Formula misreading Input [SOLVED]
Hi All,
I am using the following formula to keep track of how many tickets I work a day.
The issue is that, I have multiple tables on the same spreadsheet, and it is counting the "Columns", Is there a variable I can add to deny the Columns?
I figure it would be the does not contain option, but I can't seem to get that to work, maybe I am putting it in the wrong area.
Formula: ="Count of Oldest Tickets Below:"&COUNTIF(C6:C304, "<>")
Also, Column C is the "Account" by the way.
Columns of each table:
-- Date Opened
-- Ticket
-- Account
-- Customer
-- Address
-- Issue
-- Status
google the function COUNTIFS - maybe this can help...
- Lorenzo KimBronze Contributor="Count of Oldest Tickets Below:"&COUNTIF(C6:C304, "<>")
in the above formula - what is it not equal to?
maybe..
="Count of Oldest Tickets Below:"&COUNTIF(C6:C304, "<>0") ?
countif is looking at range C6 to C304 and searching what is "not equal to zero"
HTH- Kenneth UlrichCopper Contributor
Hi Lorenzo,
I tried that.
="Count of Oldest Tickets Below:"&COUNTIF(C6:C296, "<>Account")
And the ticket count came to 291, I mainly just need C5, C34, C43 exempted from the formula. Maybe I could try to exclude those cells in the formula?
- Lorenzo KimBronze Contributor
google the function COUNTIFS - maybe this can help...