Forum Discussion
Kenneth Ulrich
Sep 19, 2018Copper Contributor
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",...
- Sep 20, 2018
google the function COUNTIFS - maybe this can help...
Kenneth Ulrich
Sep 24, 2018Copper Contributor
Thank you.
I actually just did ="Count of Oldest Tickets Below:"&COUNTIF(C6:C297, "<>")-2 and it's giving the proper readout now.
I actually just did ="Count of Oldest Tickets Below:"&COUNTIF(C6:C297, "<>")-2 and it's giving the proper readout now.
Lorenzo Kim
Sep 24, 2018Bronze Contributor
glad it helped..