I am trying to create a formula in Cell C2 to be added from B2, but I don't
know what the value will be, the same for D2 but subtract from B2 again no
value. The subtotal could be the same as the Grand Total for some sales reps,
while others might have a reimbursement or Cash advance. Hope this makes
sense.
B2 C2 D2 E2
sub total reimburse+ Cash Advance - Grand Total
$424.00

Hi Jackie

The formula in E2 will be = sum(b2:d2) or if d2 is an unsigned -ve number
then =b2+c2-d2.

Now where do you get your numbers from from c2 and d2 will depend on how
your source data is formed and I suspect that you want you use sumif or
manually enter the numbers in thoses cells.

Please can you explain where your data comes from and the format so that
somebody may be able to help you.



--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Jackie" wrote:

I am trying to create a formula in Cell C2 to be added from B2, but I don't
know what the value will be, the same for D2 but subtract from B2 again no
value. The subtotal could be the same as the Grand Total for some sales reps,
while others might have a reimbursement or Cash advance. Hope this makes
sense.
B2 C2 D2 E2
sub total reimburse+ Cash Advance - Grand Total
$424.00

Thank you for your answer and it did help. I also found that if I changed my
format to currency and used a + or - sign it also gave me the totals I am
looking for. I am trying to set up a spreadsheet that shows hours by rate,
then a % added to the subtotal, then if there is a reimbursement or cash
advance neede for that payperiod before the net pay is applied. thanks J

"Martin Fishlock" wrote:

Hi Jackie

The formula in E2 will be = sum(b2:d2) or if d2 is an unsigned -ve number
then =b2+c2-d2.

Now where do you get your numbers from from c2 and d2 will depend on how
your source data is formed and I suspect that you want you use sumif or
manually enter the numbers in thoses cells.

Please can you explain where your data comes from and the format so that
somebody may be able to help you.



--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Jackie" wrote:

I am trying to create a formula in Cell C2 to be added from B2, but I don't
know what the value will be, the same for D2 but subtract from B2 again no
value. The subtotal could be the same as the Grand Total for some sales reps,
while others might have a reimbursement or Cash advance. Hope this makes
sense.
B2 C2 D2 E2
sub total reimburse+ Cash Advance - Grand Total
$424.00