Forum Discussion

Misleiloee's avatar
Misleiloee
Copper Contributor
May 17, 2023
Solved

Date before another date (cell range) with SUMIFS

 

Hello,

I would like to have the sum of closed topics before or at the targeted closure date. I tried to use SUMIFS but I don’t know how to put those closed before the targeted closure date, because I can’t put another formula inside SUMIFS formula like this:

 

 

=SUMIFS($A2:$A7 ; $B2:$B7 ; « Closed »;$C2:$C7;"<="&$D2:$D7)

 

 

 

How can I make it work ? I understand I need either to use another formula or adding/substracting with other formulas but I’m not sure what and how…

 

Thanks for any help!

 

 

edit: I made a sample excel sheet with column and type of data I have here

excel
Formulas and Functions
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        May 17, 2023

        Misleiloee 

        Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources