Trying to find a way to calculate subtotals for different sections of an invoice w/ data validation

excerbated123 · #2 02-03-2015, 05:31 PM

Update!

I think I know what I'm trying to do now but I still don't know how to do it.

Correct me if I'm wrong but I think I need an array formula

Basically I need to set boundaries for the formula to work within.

When I select "section" from the drop down in A4, I need that to create the beginning of the boundary in F4 & G4.

When I select "Total" from the drop down in A11 I need that to set the end boundary for the formula that sums the values in columns F & G. I then need that to display the sum in F11 & G11.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto populate & auto calculate values from other sections in the same word document	Frantic	Word VBA	2	01-24-2015 04:54 PM
data validation from another sheet	paulys	Excel	1	06-30-2014 01:40 AM
Auto populate invoice (including description) from data sheet	agenevieve	Excel	2	12-06-2012 04:48 AM
If/then formulas with data validation	shira47	Excel	1	04-09-2012 05:14 AM
Data validation with IF	Klyxrastafari	Excel	1	10-03-2011 04:41 PM