Forum Discussion

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

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",...
excel
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Sep 20, 2018

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

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

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
Sep 20, 2018

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

  • Kenneth Ulrich's avatar
    Kenneth Ulrich
    Copper Contributor
    Sep 24, 2018
    Thank you.

    I actually just did ="Count of Oldest Tickets Below:"&COUNTIF(C6:C297, "<>")-2 and it's giving the proper readout now.
    • Lorenzo Kim's avatar
      Lorenzo Kim
      Bronze Contributor
      Sep 24, 2018

      glad it helped..

Resources