•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Fromula calculating from cell number not job number.
I have this formula in the bar at top =CONCATENATE(COUNTIF($A$4:$A$116,TRUE), "/", COUNTA($D$4:$D$116), " completed ") I need the count to start at Job no. 1, not cell 4, as it misses 3x jobs, and gives a false count (job total is at 115, not 112 in total. I've changed column A in the formula to Column C, but that just gives a job count of 0/115. Any ideas please ?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#formula
#COUNTIF
#COUNTA
#cell number
#job number
#job count
#column
#A4
#A116
#D4
#D116
#completed
#false count
#job total
#start at Job no. 1
#misses jobs