Formula to sum up data using "if" function??
 

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.

Formula to sum up data using "if" function??
 

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.

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.