Forum Discussion

V A's avatar
V A
Copper Contributor
Apr 27, 2018
Solved

Need help using =sumifs()

Hello, I'm trying to figure out how to return sum of specified range, with 2 criteria, the category is "x" and also falls into a specified month(x). I'm currently using the following formula: =SUMIF...
Formulas & Functions
Need Help
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Apr 27, 2018

    Hi there.

     

    Untested.

    =SUMIFS($C:$C,$D:$D,">=01.01.2018",$D:$D,"<=31.01.2018",$A:$A,"Services")

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 27, 2018

Hi there.

 

Untested.

=SUMIFS($C:$C,$D:$D,">=01.01.2018",$D:$D,"<=31.01.2018",$A:$A,"Services")

 

  • V A's avatar
    V A
    Copper Contributor
    Apr 28, 2018
    Thank you, your formula didn't work exactly but with a few minor tweaks I got it to work. I must of gotten tunnel vision on this so I appreciate the help!
    Here is what worked
    =SUMIFS($C:$C,$D:$D,">=01/01/2018",$D:$D,"<=01/31/2018",$A:$A,"Services")

    I can't thank you enough!