Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculation Conundrum
I'm sure there is a simple solution, but after hours of research...I need help.
There are staff members planned for a project and hours that need to be multiplied times the rate to give a dollar figure per person with a bottom line total for the dollars. There may be anywhere from 1-50 people assigned to a project so not every line is filled in. For example: Name hours Rate Total Chris 50 $100 $5000 Joe 10 $125 $1250 ? #VALUE ? #VALUE Total #VALUE What is the best way to handle this? Thank you for your kind assistance. DonnaS |
#2
|
|||
|
|||
Assuming your data below starts at A1
In D2: =B2*C2 Copy this down the column as far as you need, In column D below your last cell from above: =SUM(D2:D??) changing the ?? to the row above this cell. HTH -- Ian -- "DonnaS" wrote in message ... I'm sure there is a simple solution, but after hours of research...I need help. There are staff members planned for a project and hours that need to be multiplied times the rate to give a dollar figure per person with a bottom line total for the dollars. There may be anywhere from 1-50 people assigned to a project so not every line is filled in. For example: Name hours Rate Total Chris 50 $100 $5000 Joe 10 $125 $1250 ? #VALUE ? #VALUE Total #VALUE What is the best way to handle this? Thank you for your kind assistance. DonnaS |
#3
|
|||
|
|||
Your first formula is what I have in place. I have 50 rows that could be
potentially filled in. Each of the 50 rows has a formula in the D column waiting for the rest of the data to be entered and may not be filled in. Each row that does not have data entered gives a #VALUE error, which is probably why I'm getting the same error at the bottom. It seems to me that there must be an IF statement that says something like if the cells of the formula are blank then the value should be 0. If the value was 0, then the total at the bottom would be sum of the column. Thank you for your time. "Ian" wrote: Assuming your data below starts at A1 In D2: =B2*C2 Copy this down the column as far as you need, In column D below your last cell from above: =SUM(D2:D??) changing the ?? to the row above this cell. HTH -- Ian -- "DonnaS" wrote in message ... I'm sure there is a simple solution, but after hours of research...I need help. There are staff members planned for a project and hours that need to be multiplied times the rate to give a dollar figure per person with a bottom line total for the dollars. There may be anywhere from 1-50 people assigned to a project so not every line is filled in. For example: Name hours Rate Total Chris 50 $100 $5000 Joe 10 $125 $1250 ? #VALUE ? #VALUE Total #VALUE What is the best way to handle this? Thank you for your kind assistance. DonnaS |
#4
|
|||
|
|||
DonnaS, Try =IF(AND(B2<"",C2<""),B2*C2,0) HTH -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=465548 |
#5
|
|||
|
|||
Hot dog...that did it! Thank you so much!
"Casey" wrote: DonnaS, Try =IF(AND(B2<"",C2<""),B2*C2,0) HTH -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=465548 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Equity buildup calculation | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |