•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