SUM

Occasional Visitor

I highlighted M5 to enter =SUM(K5-L5) and want to use the formula thru M40 and only M5 will calculate, not the rest of the column to M40.

I had previously done K5 =SUM(G5:J5), highlighted thru K40 and it worked.

 

What am I doing wrong?

1 Reply
Nothing wrong with the formula you are trying so far,, better edit your post & share the Workbook with us,, I'll examine & fix the issue!!