in need of assistance

F

firehound

I am trying to get the value of one column to add the sum of a second one
with the current date; for a whole month
I want to keep track of the +/- customers for the current date. The
estimated customers are already plugged in for the whole month.

Thanks for any assistance you can offer.
Example

Date budget mtd budget customers to date Estimated Customer
Customers +/-
1 100 200 250
200 50
2 500 100 600
750 -150
3 200 300 200
300 -100
4
 
H

Harlan Grove

firehound wrote...
I am trying to get the value of one column to add the sum of a second one
with the current date; for a whole month
I want to keep track of the +/- customers for the current date. The
estimated customers are already plugged in for the whole month.
Unclear.

Thanks for any assistance you can offer.
Example
....

This makes it even less clear what you want. Long column headings are
ALWAYS a mistake since they're invariably word-wrapped.

I doubt you mean just subtracting estimated customers from customers to
date.

If you want the rollong sum of one column, say column D, to be shown in
another column, say column G, then if the topmost data row were row 2,

G2:
=D2

G3:
=G2+D3

and fill G3 down as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top