Excel Function Arguments 1

[Angel79]

Hi,
I have a Excel spreadsheet created and can't figure out what function I should use to have a total carried to another cell.
What I have so far is:
cell C4 is where you would enter your data
cell E4 data
cell F4 is the total of C4+E4
cell C5 enter data
cell E5 enter data
cell F5 would have the total of F4 + C5 + E5
cell C6 enter data
cell E6 enter data
cell F6 total of F5 + C6 + E6
etc..
the formula I am using for the totals is:
IF(NOT(ISBLANK(C6)),C6+E6+F5,0) <--in cell F6

Now, I need to have the total carried down to the end of spreadsheet cell F50. But I always want the most current total to be in that cell.

If I haven't confused anyone yet by trying to explain it (LOL) please help me if you can.

Thanks,
Christa

 

[SkipVought]

Hi,

Use the SUBTOTAL function for EACH SUM ...

INCLUDING the FINAL Sum

in F4

=SUBTOTAL(9,c4:e4)

etc.

Check out SUBTOTAL Worksheet function in HELP -- VERY Useful!



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[SkipVought]

sorry -- I think I misunderstood you question

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[SkipVought]

=IF(ISBLANK(C5),"",C5+E5+F4)

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[Angel79]

well..umm...if I use the subtotal function all the way down through the F cells the previous total will show up, but I just want those cells to be blank unless there are values entered into the C and E cells on the same line.

So, I want the total that is in cell F49,if there is nothing there I want the total that is in F48, if nothing there F47....right up to F4.

I think I'm starting to confuse myself..LOL

 

[SkipVought]

Please disregard the SUBTOTAL suggestion.

Look at my LAST post SORRY

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[Angel79]

But how will that put the total down in Cell F50?

 

[SkipVought]

How 'bout

=MAX(F2:F49)

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com

 

[Angel79]

HEY..that worked!! Perfect!!

THANKS!!!

Something so simple looking and caused so much headaches. LOL

Thanks again! You Rule!