Question about Computers & Internet

Open Question

How do you create a running total based on specific date ranges?

Posted by on

  • kakima Jan 04, 2017

    Hi Jodi Riesenberg, I want to help you with your question, but I need more information from you. Can you please add details in the comment box?

    In what program?

×

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Downloading will not use the original EXIF date for photos, either 1) by creating a Folder named YYYYDDMM or similar, or 2) by saving it with jpgs.How can I get the EXIF date to save?


The EXIF date and the file system date are two totally separate things. As long as you use tools that maintain the EXIF data you will still have the original information.
I rename my photos using XNview so that the name of the file is based on the EXIF date. i.e. <Date Taken[y-m-d]>(xxx).jpg where xxx is the three digits from the original filename.

Mar 28, 2010 | Kodak EasyShare M1033 Digital Camera

1 Answer

The date created is wrong on my photos


The file properties will always show the date downloaded, since that's the date the file was created on your hard drive. The date (and time) the photo was taken is stored in the file itself, in what's known as the EXIF data.

I don't know what operating system you're using, so I can't give you specific instructions on how to get the date the photo was taken. On Windows Vista, for example, if you click (not double-click) on a file in Explorer, the date taken will appear in the status area at the bottom of the window. Other programs will have different ways of displaying the EXIF data.

Feb 10, 2010 | Canon EOS Digital Rebel XS / 1000D IS...

2 Answers

I NEED TO START A SPREADSHEET FROM SCRATH I AM A BEGINNER AT COMP


I am assuming that you want your date column to run daily - not updating itself with todays date over previous data....

In which case your column will run a daily date, You can achieve this by typing a date in the format you choose = 01/05/09, 1 May 09, etc hit return. scroll on the bottom corner of the cell you have typed the date in until it changes from a large white cross to a smaller cross and drag this down the column.

For the totals that need to subtotal autmoatically you will need to select a range - so is this total a weekly/ monthly total - How large is your range.

Once you have decided on the above - for example the in Column A the date ranges from 1st May - 31st May for a calendar month, the subtotal will need to include 31 cells - so in the Column B which is the subtotal = SUM(B2:B32)

You can copy and paste the sum into adjoining cells if you are seperating income from expenses etc.

Hope this helps.

May 21, 2009 | Computers & Internet

2 Answers

Can I get the asswer for the below questions


A book shop maintains the inventory of books that are being sold at the shop. The list has details like author, title, price, publisher and stock position. Whenever a customer wants a book, the sales person inputs the title and author and the system searches the list and displays a suitable message if it is not available. If it is available, the system displays the book details and requests for the number of copies required. If the copies are available, the total cost of the copies requested is displayed, otherwise the message ‘copies not in stock’ is displayed.
Design a system using a class called BOOKS with suitable member functions and constructors. Use new operator in constructors to allocate required memory space.

Nov 16, 2008 | Computers & Internet

2 Answers

Excel formula creation


= (a3) minus (b3) won't do it for you?

Sep 05, 2008 | Excel (SS8SATAS5128400R)

1 Answer

GUID


The GUID is created when Windows is first installed .. it's a unique number based on the BIOS system date and time (to the nearest milliscond) .. it is a unique way to identify a specific machine .. (if you 'clone' the hard drive & use the clone in another machine you will have problems ..) .

You will find it hidden in the Registry .. to dig it out Google for GUID Tool ..

Mar 25, 2008 | Dell Inspiron 2200 Notebook

1 Answer

Using if and then to add values to a cell


Try using the SUMIF function for one condition or multiple conditions. Use the SUMIF worksheet function to create a total value for one range based on a value in another range. For example, for every cell in the rage B5:B25 that contains the value "Northwind", the following formula calculates the total for the corresponding cells in the range F5:F25. Formula:
=sumif(B5:B25,"Northwind",F5:F25)

Here are SUMIF functions for multiple conditions.

=sum(if((B5:B25="Northwind")*(C5:C25="Western"),F5:F25))

=sum(if((B5:B25="Northwind")+(C5:C25="Western"),F5:F25))

=sum(if(B5:B25="Northwind",IF(C5:C25="Western"),1,0)))

Also check your help for SUMIF functions.

If this helps you, Please rate me. Thanks, Patty

Dec 09, 2007 | Computers & Internet

Not finding what you are looking for?

Open Questions:

Computers & Internet Logo

Related Topics:

26 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...