K
kledford
I input data on a daily basis and have need to keep a daily runnin
total.This data includes a date and invoice number and the hours worke
aganist that invoice. I also need a column in which to report hours t
date. I'll try to list an example below
A B C D
1/2/04 12345 3 3
1/3/04 23456 2 2
1/3/04 12345 2 5
1/4/04 12345 1 6
Column a is the date,column b is the invoice number, column c is th
hours worked aganist this invoice ,column d is the running total. Th
first instance above is the initial entry of 12345 so the c and
column data would be the same.The second instance of the invoice 1234
shows 2 hours today but now column d needs to show the initial hour
plus todays hours as a running total. These list get very long a
usually some invoices will appear many times.
The number of entries grows everyday and there are many differen
invoice numbers mixed in which makes it difficult to pick out th
totals for billing. I've worked with this and have learned a great dea
but haven't quite been abel to figure this one out. I'm really new wit
excel and I'm not even sure this can be done.Thanks in advance for an
help or guidance you may be abel to provide. I have been abel to ge
the totals I need usinf countif and sumifs but I can't figure out ho
to show a daily running total. With the formulas I use when it does th
total because I'm using the completer column as the range and th
formula is listed in every cell in column d it will update the total i
all instances of the invoice number rather than each day showing
running total
total.This data includes a date and invoice number and the hours worke
aganist that invoice. I also need a column in which to report hours t
date. I'll try to list an example below
A B C D
1/2/04 12345 3 3
1/3/04 23456 2 2
1/3/04 12345 2 5
1/4/04 12345 1 6
Column a is the date,column b is the invoice number, column c is th
hours worked aganist this invoice ,column d is the running total. Th
first instance above is the initial entry of 12345 so the c and
column data would be the same.The second instance of the invoice 1234
shows 2 hours today but now column d needs to show the initial hour
plus todays hours as a running total. These list get very long a
usually some invoices will appear many times.
The number of entries grows everyday and there are many differen
invoice numbers mixed in which makes it difficult to pick out th
totals for billing. I've worked with this and have learned a great dea
but haven't quite been abel to figure this one out. I'm really new wit
excel and I'm not even sure this can be done.Thanks in advance for an
help or guidance you may be abel to provide. I have been abel to ge
the totals I need usinf countif and sumifs but I can't figure out ho
to show a daily running total. With the formulas I use when it does th
total because I'm using the completer column as the range and th
formula is listed in every cell in column d it will update the total i
all instances of the invoice number rather than each day showing
running total
