Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

I am trying to figure out how to do a three leveled formula.

Details...

I have three columns of information.

What I need figure out is how I can write a formula that will find a

static 'Serial Number', filter by 'Model' and then

sum the time.

example...

Serial Number = 1000

Model = AAA, BBB, CCC, AAA, AAA

Time = 10, 20, 30, 25, 5

I would find serial number 1000. Based on that, their might be

different models using the same serial number.

I want to filter by each model, in this example I have (3) AAA, (1)

BBB and (1) CCC all under the same serial number.

I will need to take all the model 'AAA' and find out their times (10

+ 25 + 5) and sum them to get the total time of 40.

I would then repeat this process for the same serial number but the

other models where BBB = 20 and CCC = 30

Does anyone know of a way to do this?

Yes, there are a couple of ways. I'd suggest you loook at array formulas

(first) and D-functions (second). Here are some articles from my site to

get you started:

http://www.grbps.com/Excel5.pdf (array formulae)

http://www.grbps.com/Excel3.pdf (D-functions)

I'd start with arrays since D-functions require your sheet to be set up

in a certain way before they'll work.

Didn't find what you were looking for?
Find more on Three Leveled Formula
Or get search suggestion and latest updates.

Related Topics:

- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- Array Formula
- Copy down formula with vba
- Loop in formula
- formula help but not vba please
- How to add several conditions for formula "SUMIF"
- combining formula
- VBA code to add values in two cells which have formulas
- VBA or array formula?
- Paste Formula help
- R1C1 Formula
- Formula using range name in VBA code
- searching within formulas
- Populate Formula(Function) in rows
- Getting a formula to copy from inside VBA
- VBA Formula prob
- Stuck on copying formula from 1 sheet to another
- Named formula/Windows dialog boxes
- cells containing formula that refer to user-defined VBA function
- sum formula
- Manually creating a row outline with no formula anywhere
- Blank Formula bar
- Disabling Formulas, Not calculation
- Quotations in Formulas and strings