• Status: Solved
• Priority: Medium
• Security: Public
• Views: 54

# Sumif formula

Hello!

This is my current formula: =SUMIF(\$K\$11:\$K\$700,\$M12,\$J\$11:\$J\$700). I am looking for an adjusted version that will reference column B with the word "January". In other words,  a formula will sum up all the data that occurred during the month of January only.

thanks
0
• 2
• 2
1 Solution

Commented:
do like this =SUMIF(\$K\$11:\$K\$700,"January",\$J\$11:\$J\$700)
0

Commented:
or if you have a separate condition where the Months are in B  then here is it  =SUMIFS(\$J\$11:\$J\$700,\$K\$11:\$K\$700,\$M11,\$B\$11:\$B\$700,"January")
0

Author Commented:
That's not what I need. My formula stays as is:=SUMIF(\$K\$11:\$K\$700,\$M12,\$J\$11:\$J\$700). It needs to reference an additional column(column B) and only pick data that occurred during January.
0

Author Commented:
thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.