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!

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!

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!