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

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
Ladkisson
Asked:
Ladkisson
  • 2
  • 2
1 Solution
 
ProfessorJimJamCommented:
do like this =SUMIF($K$11:$K$700,"January",$J$11:$J$700)
0
 
ProfessorJimJamCommented:
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
 
LadkissonAuthor 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
 
LadkissonAuthor 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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now