Formula

Myriam Weiler

I am attempting to sum in Summary the total amount spent on a trip by individual deapartment in this calendar year. I have the following:

=SUM([TOTAL ESTIMATED COST]:[TOTAL ESTIMATED COST], Department:Department, "Trauma Healing Enterprise", [Return Date]:[Return Date], YEAR(@cell) = 2020))

I am learning as I go so this formula might be way off.

Thank you in advance for your help!

Mathieu PERSICO

Hi Myriam,

Use the SUMIFS function instead of SUM.