Calculatiing Formula

Shazz

New member
Joined
May 9, 2012
Messages
15
Reaction score
0
Points
0
Morning All,

I have a Cash sheet with totals on it but I can not figure something out.

When entering £1.50 into K6, L6 shows £1.50
When entering £2.00 into K7, L7 shows £3.50 and so on, but I do not want to see £3.50 in all the cells in L but when I enter figures into the other cell I want the L column to change to the new calculation and so on.

L39 will show the sum of column K. I hope this makes sence, I am not very good at explaining things. I have attached a copy of the cash sheet to hopefuly explain it self.

Shazz
xx
 

Attachments

  • DTD Cash Sheet.xls
    35 KB · Views: 15

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
First of all, when picking up a single cell, you do not need to use SUM, you can reference the cell directly. So in L6 do not use =SUM(K6), just use =K6.

Then, when you do add multiple cells, you do not need SUM and +, the + sums the element, so one or the other suffices. So instead of =SUM(L6+K7), use =SUM(L6,K7) or =L6+K7.

To your problem, use this in L7

=IF(K7="","",L6+K7)

and copy down. In words, you test if K7 is blank, if so return a blank into the cell, otherwise do the sum.
 
Top