Hi and thank you in advance!
I have the below formula where I am trying to get the amounts to populate from column N if the cell in J column is Yes and the due date in column M is within the month selected (from a data validation list) in cell C1 but it isnt populating anything. Please help!
Thank you!
=SUMIFS(BEAUDESERT!J:J,BEAUDESERT!N:N,"Yes",BEAUDESERT!M:M,">="&EOMONTH(C1,0))
Try =SUMIFS(BEAUDESERT!N:N,BEAUDESERT!J:J,"Yes",BEAUDESERT!M:M,">="&EOMONTH(C1,0))
Still showing as $0.00 unfortunately.
=SUMIFS(BEAUDESERT!N:N,BEAUDESERT!J:J,"Yes",BEAUDESERT!M:M,">"&EOMONTH(C1,-1),BEAUDESERT!M:M,"<="&EOMONTH(C1,0))
No luck....
See yellow banner on how to attach a workbook.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Here is a copy of my spreadsheet in case it helpsOutco copy.xlsx
You are comparing a text date (NOV) vs an Excel date so you will never get a match.
Do yo want the results ONLY for the date in C1 i.e month of November ?
Will be back shortly.
I am hoping that if I need the figure for a particular month I can select the month (happy to put to and from dates if that works) and the figures will populate for that timeframe. Thanks soo much for your help!.
Try
in I3
=IFERROR(SUMPRODUCT((INDIRECT("'"&H3&"'!$N$2:$N$1000"))*(MONTH(INDIRECT("'" &H3 & "'!$M$2:$M$1000"))=MONTH($I$1&0))),"")
copy down
Last edited by JohnTopley; 11-23-2022 at 02:44 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks