Formula to sum up data using "if" function??
THank you! That is what I meant. I knew it was something with "IF" but wasn't
all that sure which one!
"Bob Phillips" wrote:
Just use SUMIF to get the total percentage paid
=SUMIF(percent_col,2%)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Rachael" wrote in message
...
I don't know if the IF function is what I want, so maybe someone can help
me
out.
I have drop-down lists of percentages across the top of my spreadsheet.
The
user can select any percentage from 2% to 7%, but 99.9% of the time it
will
be either 2%, 4%, or 5%.
Then there is a calculation at the bottom where totals in each column are
multiplied against what ever percentage has been chosen for than column.
I need a formula that will look at my rows of calculations and see if it's
2%, 4%, or 5%. Then I need it to look at the final value (total) and sum
up
the total. What I mean is, I need it to sum up the final total for all 2%
values, all 4% values, and all 5% values.
Right now this is what it is (in each column, going across, where the
"rate"
and "percentage" are taken from drop down lists above):
Total Time (hours and minutes) X rate (in dollars) = Total Paid X
percentage
= Percentage paid
I need a formula to calculate the sums of "percentage paid" for each of
2%,
4% and 5% in a separate cell.
|