Results 1 to 4 of 4

Embedding SUMPRODUCT & SUMIF

Threaded View

sstyre Embedding SUMPRODUCT &... 01-19-2012, 04:49 PM
NBVC Re: Embedding SUMPRODUCT &... 01-19-2012, 04:59 PM
sstyre Re: Embedding SUMPRODUCT &... 01-19-2012, 05:03 PM
daddylonglegs Re: Embedding SUMPRODUCT &... 01-19-2012, 05:30 PM
  1. #1
    Registered User
    Join Date
    01-19-2012
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2010
    Posts
    18

    Embedding SUMPRODUCT & SUMIF

    Hi there, I have a need to do a calculation based on a few criteria. I can do a simple SUMIF to get one portion of it working correct, but when I try to add in additional details to pull a specific date range of that data, I'm hitting a brick wall. (The spreadsheet I am using is a full array of columns up to CC, with over 200k rows, so I didn't want to upload such a massive file, so the attached is a simplified version)

    Column A: Client Name
    Column B: Total $$
    Column C: Invoice Date

    What I want to do is take the following =SUMIF(A2:A100000,"Client Name", B2:B100000) that gives me the total sum of Column B, and add in functionality from a date filter as well. For example, if I do a =SUMPRODUCT((C2:C100000>=DATEVALUE("1/1/2010"))*(C2:C100000<=DATEVALUE("31/1/2010")),B2:B100000) I can get the total for all clients for the date range, but I'm at a loss as to how to incorporate both of these together, so I can get the total for a client for a given month.

    Any help would be greatly appreciated!

    Thanks!
    Attached Files Attached Files
    Last edited by sstyre; 01-19-2012 at 05:04 PM. Reason: Solved

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