Forum Discussion
LANR
Feb 19, 2025Copper Contributor
I need formula help!
This is wrecking my brain. I need serious help. I have a table of data, below, and I need a formula in the box on the right, to add the totals per department when the date in K1 is the same as the ...
mirzayasir
Feb 25, 2025Copper Contributor
I took data from the image you show; here is the formula required by you.
=SUMIFS($E$2:$E$26,$C$2:$C$26,$J3,$A$2:$A$26,$K$1)