Results 1 to 17 of 17

Excel 2007 : count number of transaction in a month when date is entered, also total

Threaded View

russellcorey count number of transaction... 09-05-2010, 12:38 PM
russellcorey Re: count number of... 09-05-2010, 02:00 PM
arthurbr Re: count number of... 09-05-2010, 04:05 PM
TMS Re: count number of... 09-05-2010, 05:26 PM
russellcorey Re: count number of... 09-05-2010, 06:17 PM
russellcorey Re: count number of... 09-06-2010, 12:22 PM
TMS Re: count number of... 09-05-2010, 06:45 PM
MarvinP Re: count number of... 09-05-2010, 06:47 PM
russellcorey Re: count number of... 09-05-2010, 08:26 PM
MarvinP Re: count number of... 09-05-2010, 11:46 PM
TMS Re: count number of... 09-06-2010, 02:40 AM
TMS Re: count number of... 09-06-2010, 12:55 PM
russellcorey Re: count number of... 09-06-2010, 02:15 PM
TMS Re: count number of... 09-06-2010, 02:20 PM
russellcorey Re: count number of... 09-06-2010, 05:02 PM
TMS Re: count number of... 09-06-2010, 05:05 PM
TMS Re: count number of... 09-06-2010, 05:11 PM
  1. #1
    Registered User
    Join Date
    09-05-2010
    Location
    texas
    MS-Off Ver
    Excel 2007
    Posts
    7

    Unhappy count number of transaction in a month when date is entered, also total

    Hello,
    I apologize in advance, this topic is over my head so I may over explain.

    my spread sheet is organized by agent name, then each agent has 4 transactions per row, columns reading:
    name, start date, DA# 1, Street 1, Close Date, Bonus $ 1, Posted 1, DA #2, street 2, .....and so in through the 4th DA

    Under this table I would like to not only count how many DA's have posted each month, but also total the Bonus paid for that month.
    I have columns labeled:

    Month, (blank), # of closings, Total Bonus

    My problem is I don't know how to tell the formula to count only the dates in January (or any month) when the actual dates are entered in the spreadsheet in the following format 01/01/10, and I need it to search multiple columns (ie, all 4 "posted" columns)

    Additional problem... I also have no clue how to total the bonuses for a given month when the $amount is in one column and the date is is paid is in another.

    I have searched through HELP and tried COUNTIF and COUNTIFS and tried to use a pivot table. I can't quite seem to get it.

    Thank you in advance for any assistance you can provide.

    Respectfully,
    Last edited by russellcorey; 09-07-2010 at 04:38 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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