Difference function and argument for two simple amounts

[lawrencae]

This is a request for help with a simple difference calculation for two
adjacent cells, as described below.

The example below may well be more understandable than my attempt to explain
what is needed.

Function and argument needed for the positive or negative difference between
the amount for a given day’s sales last year and the amount for a given day’s
sales this year.

Last year’s daily sales are the standard, so if this year’s daily sales are
more than last year’s sales, the difference will be a positive amount, but if
this year’s daily sales are less than last year’s, the difference will be a
negative amount.

Running sums will be shown for each column.

Below is the proposed layout example. Each row is for one day in a given
month. Amounts shown are for four days only. The SUM totals are at the bottom
of each column.

Last Year This Year Difference
Gross Sales Gross Sales
1214.00 1113.00 -101.00
1065.00 1712.00 647.00
2301.00 2812.00 511.00
4216.00 3330.00 -886.00

SUMs for the month

8796.00 8967.00 171.00

All the function arguments my search has turned up are for more complex
difference function arguments. I am at wit’s end. Your help will be deeply
appreciated.

 

[CLR]

Maybe......

=(A2-B2)*-1

Vaya con Dios,
Chuck, CABGx3

 

[Sandy Mann]

Why not just

=B2-A2

or am I missing something?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[lawrencae]

CLR,

Thanks for trying. I really appreciate it, even though it was not the answer
I used, which proved to be correct. That correct answer was:


Assuming your headers are in row 1, clumns A:C and your data starts in row
2.

In C2 put =B2-A2, then copy this down the column as far as you need.

Below all the data in column A (eg in A100) put =SUM(A2:A99) and copy this
to B100.

Thanks again and regards,
Lawrence

 

[CLR]

Sandy,
There are mornings where only one cup of coffee does it for me, and then
there are mornings where it takes substantially more.........<g>

Vaya con Dios,
Chuck, CABGx3

 

[lawrencae]

Sandy,

Thanks for the follow through. You are to be applauded. That brands you as a
real stand up person in my little book.

=B2-A2 is the correct answser. CLR had mistakenly written, Maybe......

=(A2-B2)*-1

Vaya con Dios,
Chuck, CABGx3

Now to Scotland. I was married at Denny and Dunipace, Scotland a long time
ago in another life (well, almost). I traveled by did not make it to Perth
yet. I am in the Philippines as I write this.

Best regards,

Lawrence S. Miller
(e-mail address removed)

 

[Sandy Mann]

You're Very welcome. Chuck's answer does work as well.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

I know that feeling *very* well!

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[lawrencae]

Okie, dokie, give Chuck a pat on the ole back for me.

I believe you can tell that I am a newbie with Excel. I am involved in
setting up a Daily Report (sales, expenses, and hoped for profit). It is
quite a chore for me, but I hope to have it done shortly.

Thanks to all your help.

I hope you did not mind that I tried both your email addresses Sandy.

Cherrio.

Lawrence S. Miller
(e-mail address removed)