Thread: [Solved] Trying to find a way to calculate subtotals for different sections of an invoice w/ data validation
View Single Post
 
Old 02-03-2015, 05:31 PM
excerbated123 excerbated123 is offline Windows 8 Office 2013
Novice
  
Join Date: Feb 2015
Posts: 10
excerbated123 is on a distinguished road
Default
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.
Reply With Quote