Add sub totals

**sindy1232** · 05-26-2007, 11:04 AM

I am putting together a list like this;
Client Location Product Cost Sub-total
ABD Here Slurry $125.
ABE There Mud $525. $650.

Where I want to enter the cost and have Excel do the sub-total automatically.
Is there an easy way to do this? The spread sheet is already 147 entries long and will only grow and I don't want to have to figure out the sub-totals each time.

Thank you ahead of time because you have all been a great help in the past.
Sindy

**duane** · 05-26-2007, 11:19 AM

is there any criteria to the subtotal, or is it simply the total of all entried in column D?

if so, in cell e2 and copied down as far as you want

=if(isblank(d2,"",sum(d$1:d2))

**sindy1232** · 05-26-2007, 11:32 AM

Job # Job Name Location Treatment Cost YR Totals

2001-07 Western Rock Office Patch 126.00
2002-07 Rich Electric Patch 100.00
2003-07 Heritage Park HOA Slurry 410.00

This is what I am trying to do.
Job # in A then Job Name in B then Location in C then Treatment in D then Cost in E and then have a running sub-total in F.
Also to enter a function would I just highlight F and paste?

I am soooo lost. LOL I would upload the file but I can not upload an .xls file here.

**duane** · 05-26-2007, 11:59 AM

try this entered in cell f2 and then copy down column f for as many rows as you may ultimately need.

=if(isblank(e2,"",sum(e$1:e2))

this will sum all entries in column e down to current row

**sindy1232** · 05-26-2007, 12:10 PM

Thanks a ton.
This is what I found out and it worked.

In cell F4, put 0. In cell F5 put this formula:

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

Then fill down from F5 (see Fill Down With Fill Handle) to where you need subtotals.

Because your cost column contains blanks, I can't test for blanks and hide the totals after your last cost entry.

**VBA Noob** · 05-26-2007, 12:25 PM

Please read forum rules below. Thread locked for cross posting

VBA Noob

Add sub totals

LinkBack

Thread Tools

Display

Add sub totals

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions