Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
How do I use the "if" and "round" function in the same formula ? | Excel Worksheet Functions | |||
Filtering Data with Rank Function | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
Can "IF" function display calculated data as bold? | Excel Worksheet Functions |