Different Example: Writing a formula with several criteria?

R

Rodney

I tried to fix my first post so maybe it will make more since. On every trip
I need the total in each row to update. So the total for Site
Preparation after the first trip needs to be 2%, on the secound Trip it needs
to be 100%. Same for the other rows.
Framing 2nd Trip the total needs to be 24%
3rd Trip the total needs to be 36%
4th Trip the total needs to be 84%
Plumbing 3rd Trip the total needs to be 2%
4th Trip the total needs to be 4.8 round to 5%
I know the formula to get the percentage but how do I get it to update after
the next trip?
Jan Feb Mar AprValue 1 2 3 4
TOTAL
 

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

Multiple Criteria formula 5
Writing a formula with several criteria? 3
Extracting data from Multiple columns to a Single row 3
How do I count the number of brackets within a formula (cell)? 2
Sorting Data in a Row Question 5
Still trying to average 4 worksheets and having formula problems 3
Datepart year - + 6 months 3
Formula or macro to analyze data vertical and horizontal? 1

Top