Results 1 to 11 of 11

calculate amount of days by name

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-27-2015
    Location
    Los Angeles, California
    MS-Off Ver
    office 2010 pro
    Posts
    238

    calculate amount of days by name

    hi guys, my name is rachel, i have a quick question, hope someone can help:

    I have a workbook where:

    Column A = Date such as 2/1/03
    Column B = Day that corresponds with Column A (2/1/03 = Wednesday)
    Column D = Cell D2 = Total amount of Wednesdays from cell range B2:B17
    Column E = Cell E2 = Total amount of Saturdays from cell range B2:B17

    I know how to calculate the sum of each, but my problem is when i run into duplicates that correspond to the date such as:

    2/1/03
    2/22/03
    7/9/03
    10/25/03
    12/25/03

    These dates have duplicates so i don't want to count the corresponding day twice.

    There should be 7 Wednesdays and 4 Saturdays.

    Can anyone provide a formula for this, in cells D2 & E2? Thanks in advance to anyone who takes the time to help me!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calculate a date dervied from 3 cells + calculating the amount of spec days.
    By RachelMads02 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-02-2016, 09:57 AM
  2. [SOLVED] Calculate Projected Annual amount from Dollar value (Amount) and varying time intervals
    By old dawg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2016, 07:29 PM
  3. [SOLVED] How to calculate debtors ageing amount in days on FIFO basis
    By King_BD in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-20-2015, 10:57 PM
  4. Replies: 2
    Last Post: 11-21-2014, 09:35 AM
  5. Calculate amount of days per year within range
    By constructionbart in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2014, 05:24 AM
  6. Replies: 6
    Last Post: 02-23-2010, 04:41 AM
  7. How can I calculate amount of time left based on amount spent?
    By KLD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 11:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1