Results 1 to 12 of 12

Payroll - Combine SUMPRODUCT, SUMIF, COUNTIF within date range

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2007
    Posts
    14

    Smile Payroll - Combine SUMPRODUCT, SUMIF, COUNTIF within date range

    The attached spreadsheet has a "master" workesheet in which I enter customer info, salesperson info, and date. The totals spreadsheet automatically calculates number of sales, contact value.

    I need to modify the following formulas to only calculate the data within a date range shown in 2 cells.

    =COUNTIF(Master!A1:A176,PayPeriod!A4)
    =SUMPRODUCT(--(Master!A1:A176=Totals!A4),(Master!K1:K176))
    =E4SUMPRODUCT(--(Master!A1:A176=Totals!A4),(Master!K1:K176))

    Attached is what I am talking about. The columns I need help with are yellow.

    I could find anything like this by searching.

    THANK YOU!
    Attached Files Attached Files

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