Excel Formula misreading Input [SOLVED]

[Kenneth Ulrich]

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

[#2]

="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

[#3]

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?

[#4 · Accepted solution]

google the function COUNTIFS - maybe this can help...

[#5]

Thank you.

I actually just did ="Count of Oldest Tickets Below:"&COUNTIF(C6:C297, "<>")-2 and it's giving the proper readout now.

[#6]

glad it helped..