Forum Discussion

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
Sep 20, 2018
google the function COUNTIFS - maybe this can help...

Lorenzo Kim

Bronze Contributor

Sep 20, 2018

="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
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
  Bronze Contributor
  Sep 20, 2018
  google the function COUNTIFS - maybe this can help...
  - 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.