Forum Discussion

Kenneth Ulrich's avatar
Kenneth Ulrich
Copper Contributor
Sep 19, 2018

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

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Sep 20, 2018

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

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze 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 Ulrich's avatar
      Kenneth Ulrich
      Copper 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 Kim's avatar
        Lorenzo Kim
        Bronze Contributor

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

Resources