Forum Discussion

LANR's avatar
LANR
Copper Contributor
Feb 19, 2025

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 date in column A. 

Further down the page, the date in column A changes to 17/02/25. When i change the date in K1 to 17/02/25, i want the totals in K3-K13 to show only the totals from the data including the same date.

 

I hope that makes sense?

 

Please help me :(

 

I used a SUMIF Function =(SUMIF(C2:C103,TEXT(J3,"0"),E2:E103)) to total the departments, which has worked perfectly, but I cannot apply the date in column A and cell K1

 

 

Thank you to anyone who can help me! 

community
microsoft 365
  • mirzayasir's avatar
    mirzayasir
    Copper Contributor
    Feb 25, 2025

    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)

  • TimLingo's avatar
    TimLingo
    Icon for Microsoft rankMicrosoft
    Feb 21, 2025

    I changed your data into a table which is why the formula is not saying the columns. You can change "Table1[Fuel Net Cost]" to E2:E103, etc. You may also want to put the $ around it as you copy the formula down. 


    =SUMIFS(Table1[Fuel Net Cost],Table1[Department],$K$5:$K$15,Table1[Invoice date],$K$3)

Resources