+ Reply to Thread
Results 1 to 2 of 2

Dates - Several Days In a month to month only

  1. #1
    Registered User
    Join Date
    02-28-2006
    Posts
    1

    Dates - Several Days In a month to month only

    Problem below

    14-Oct-06 5,000
    30-Oct-06 15,000

    How do I get this to show as:

    Oct-06 20,000

    Is there a formula to do this?

  2. #2
    Bob Phillips
    Guest

    Re: Dates - Several Days In a month to month only

    ="Oct-06 "&TEXT(SUMPRODUCT(--(MONTH(A1:A100)=10),B1:B100),"#,##0")

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "Andy_Pimp" <Andy_Pimp.23xqon_1141123204.639@excelforum-nospam.com> wrote in
    message news:Andy_Pimp.23xqon_1141123204.639@excelforum-nospam.com...
    >
    > Problem below
    >
    > 14-Oct-06 5,000
    > 30-Oct-06 15,000
    >
    > How do I get this to show as:
    >
    > Oct-06 20,000
    >
    > Is there a formula to do this?
    >
    >
    > --
    > Andy_Pimp
    > ------------------------------------------------------------------------
    > Andy_Pimp's Profile:

    http://www.excelforum.com/member.php...o&userid=31990
    > View this thread: http://www.excelforum.com/showthread...hreadid=517243
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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