How do I sum up a range of cells, only whenthe last cell has data in it?

G

gpem

Hi all,
I want to add up a range of cells but only when the last cell in the range has data in it.

Example - if I have the range A1:AB1 and want to sum up the total (I can do that bit) but I don't want to perform the calculation until the last cell in the range has data in it, how do I write the formula

Thanks for your help
 
B

Bob Greenblatt

Hi all,
I want to add up a range of cells but only when the last cell in the range has
data in it.

Example - if I have the range A1:AB1 and want to sum up the total (I can do
that bit) but I don't want to perform the calculation until the last cell in
the range has data in it, how do I write the formula

Thanks for your help
Click to expand...
In AC1, enter the formula:
=if(len(ab1)=0,²²,sum(a1:ab1))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I exclude a cell from a range? 4
sum based on value in a range 0
Naming non-contigent cells with vba 5
Footer On Last Page Only Not Working 1
Looking to added up based on a character from cell range 1
Displaying a range based on a cell's contents 3
Excel 2013: AutoFilter and SUM() 1
Finding last constant in range 1

Top