I have a formula built that uses the SUMIFS function on 3 different criteria.
However, one of the criteria is the date and I need it to recognize the date by month only. Does anyone have any suggestions on how to get the formula attached to work without adding any new columns to the source? I simplified my formula in the attached file.
Data is downloaded daily so I need a quick formula.
Thanks!!
Multiple Sumifs.xlsx
Try SUMPRODUCT instead
=SUMPRODUCT(('Sales Document Tracking '!$F$2:$F$20),('Sales Document Tracking '!$E$2:$E$20=B$1)*('Sales Document Tracking '!$C$2:$C$20=$A6)*('Sales Document Tracking '!$B$2:$B$20=$C$1)*(TEXT('Sales Document Tracking '!$D$2:$D$20,"mmm")=B$3))
Avoid using full column ranges with SUMPRODUCT. This will eat up considerable resources and slow down the workbook.
Life's a spreadsheet, Excel!
Say thanks, Click *
You're awesome. Thanks Ace.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks