MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Three Leveled Formula

  Asked By: Kevin    Date: Sep 27    Category: MS Office    Views: 2047

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


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.


Serial Number = 1000


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?



1 Answer Found

Answer #1    Answered By: Gina Tanaka     Answered On: Sep 27

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.