Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Subtotaling by date in a running list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jeff S - 18 Jan 2008 07:04 GMT
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 - 18 Jan 2008 07:16 GMT
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 S...@discussions.microsoft.com>
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
[quoted text clipped - 12 lines]
>
> Thanks for the help!
Jeff S - 18 Jan 2008 17:09 GMT
Carlo,
That's beatiful!  Thank so you much.  It works perfectly!

Jeff

> Hi Jeff
>
[quoted text clipped - 25 lines]
> >
> > Thanks for the help!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.