CONDITIONAL SUM BASED ON MULTIPLE CRITERIA

Question

Hi, I need to add a range of cells using two different criterias:

1. Criteria 1: Project description .
2. Criteria 2: The amount to be added needs to be in an interval of dates. For example if the collection date is between 01/31/2025 and 02/28/2025 please add for Construction 1 in 02/28/2025. I tried using SUMIFS with several criterias but the formula is not working. a separate issue is that the table is organized vertical but the output should be horizontal . Please see below. This is the formula I was using =SUMIFS($AM$7:$AM$150,$AJ$7:$AJ$150,D32,$AL$7:$AL$150,O31>AL7>N31)

Thank you!

Answer 1

Try this:

=SUMIFS($AM$7:$AM$150,$AJ$7:$AJ$150,D32,$AL$7:$AL$150,"<"&O31,$AL$7:$AL$150,">"&N31)

I hope I guessed correctly with the dates to compare in O31 and N31 for the greater than and less than, but it was difficult from the illustrations to determine the columns/rows for certain. If not, then reverse them.