Subtotaling by date in a running list
 

I run a community center in a developing country where we do low-cost
photocopying. To help track sales I'm trying to create a sheet that looks
like:
Col A Col B Col C Col D
Date # copies price daily sub-total

Our employee enters the transactions throughout the day. I want the scheet
to automagically do the daily sub-total, without user intervention. The
number of transactions varies each day.

I'm looking for a formula for Col D that will check the date of the next row
down. If it has changed, then run sub-total for the current day's sales. If
it has not, return a null. Is that possible? I've ran a search on "date
subtotal" and looked at all the threads but haven't found my answer.

Thanks for the help!

Subtotaling by date in a running list
 

Hi Jeff

Try this in column D (assuming that the data starts in A2)
=IF(A2<A3,SUMIF($A$2:$A$10000,A2,$C$2:$C$10000)," ")
I am not sure, if you need to some calculations, but i assumed that in
Column C you have the prices which have already been calculated,
otherwise just tell me.

Cheers
Carlo


On Jan 18, 4:04*pm, Jeff S <Jeff
wrote:
I run a community center in a developing country where we do low-cost
photocopying. *To help track sales I'm trying to create a sheet that looks
like:
Col A * * Col B * * * *Col C * * *Col D
Date * * *# copies * *price * * *daily sub-total

Our employee enters the transactions throughout the day. *I want the scheet
to automagically do the daily sub-total, without user intervention. *The
number of transactions varies each day.

I'm looking for a formula for Col D that will check the date of the next row
down. *If it has changed, then run sub-total for the current day's sales.. *If
it has not, return a null. *Is that possible? *I've ran a search on "date
subtotal" and looked at all the threads but haven't found my answer.

Thanks for the help!

Subtotaling by date in a running list
 

Carlo,
That's beatiful! Thank so you much. It works perfectly!

Jeff

"carlo" wrote:

Hi Jeff

Try this in column D (assuming that the data starts in A2)
=IF(A2<A3,SUMIF($A$2:$A$10000,A2,$C$2:$C$10000)," ")
I am not sure, if you need to some calculations, but i assumed that in
Column C you have the prices which have already been calculated,
otherwise just tell me.

Cheers
Carlo


On Jan 18, 4:04 pm, Jeff S <Jeff
wrote:
I run a community center in a developing country where we do low-cost
photocopying. To help track sales I'm trying to create a sheet that looks
like:
Col A Col B Col C Col D
Date # copies price daily sub-total

Our employee enters the transactions throughout the day. I want the scheet
to automagically do the daily sub-total, without user intervention. The
number of transactions varies each day.

I'm looking for a formula for Col D that will check the date of the next row
down. If it has changed, then run sub-total for the current day's sales.. If
it has not, return a null. Is that possible? I've ran a search on "date
subtotal" and looked at all the threads but haven't found my answer.

Thanks for the help!