Multiple Criteria formula

R

Rodney

Still looking for an answer to a problem

ITEM %VALUE TRIP TRIP TOTAL
Feb Mar
Slab (10%) 40% 100%
Framing (20%) 40%
Electric (15%) 10%

Ok here's my problem, I need to have the Total change on every trip by
multipling the %Value column by the percentage completed of that Item on each
trip.
So for trip in Feb there is only one total which is in the Slab row and it
should be 4%.
The next trip in Mar the total for each Item should be as follows.
Slab 100%
Framing 8%
Electric 1%
On each trip that follows the total needs to update every time I put a new
percentage in the Trip column.

So is there a way to do it.
 
S

Shane Devenshire

Hi again,

I'm trying to make sense out of your "results"

The total for Feb Slab is 10%*40%=4%
but Mar Slab is 10%*100% you get 100% I get 10%?
 
R

Rodney

Ok, my bad on that with 1 too many zeros. 100% of the work done will be 10%
on the total.

I didn't mean for the ( ) to represent a negative, just that they were
different from the other percentages. Sorry about that. I've just had a hard
time figureing this out. Thanks
 
S

Shane Devenshire

Hi,

You will find it best to think the problem through as much as possible
before posting it, the main reason is that a lot of us won't spend the time
asking for clarifation, we will just ignore the question. I'm a little more
vocal than many.

Anyway, that said..

Assume that your first row of data is row 3 and the total cell is E3 the
formula:

=B3*C3+B3*D3

Will work or you can simplify it to

=B3*(C3+D3)

If you are going to have many months then

=B3*SUM(C3:D3)

will prove easier to expand.
 
R

Rodney

Each trip there's a new total percentage completed that needs to be multipled
by the number in the value column.
In Feb there was 40% of the slab completed but when I went back in March it
was 100% completed. So I can't add the two together then multiple by the 10%
value that the slab represents. It has to be .10x.40 then .10x 1.00 the next
time but still show up in the total column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Different Example: Writing a formula with several criteria? 0
Writing a formula with several criteria? 3
How can count the number of cells that fulfill certain criteria in other cells 2
Summing SUBTOTAL math function 2
Macro to insert rows at varied locations 0
Counting multiple occcurrences between date range 3
Count and Sum multiple values for a single entry 2
How do I combine text fields in Access 2

Top