Sum If Formula is only calculating one column in the defined range.

[KMW]

Good afternoon, I am not terribly experienced with Excel and cannot understand why the sum if formula of =SUMIF($O$11:$O$17,"COMP TIME",$M$11:$N$17) is not calculating the sum of both columns M and N when the word COMP TIME is filled in column O, it only pulls the sum of column M. If I change that formula to =SUMIF($O$11:$O$17,"COMP TIME",$N$11:$N$17) then it calculates only the sum of column N (which makes sense to me) but it needs to calculate both column M and N for any amount of time that is designated comp time and return that total in cell M32. My guess is that due to my inexperience that I have not written the formula correctly and that's why it will not sum to 2 columns that it needs to look at and that it is probably a simple fix. If anyone can assist, I would appreciate it.

 

[Sufiyan97]

Try

=SUMPRODUCT(($O$11:$O$17="Comp Time")*$M$11:$N$17)

 

[Fluff]

Hi & welcome to MrExcel.
You cannot use sumifs like that, try

=SUMPRODUCT(($O$11:$O$17="COMP TIME")*($M$11:$N$17))

 

[KMW]

Try

=SUMPRODUCT(($O$11:$O$17="Comp Time")*$M$11:$N$17)

Thank you very much, I appreciate you! It worked perfectly.

 

[KMW]

Hi & welcome to MrExcel.
You cannot use sumifs like that, try

=SUMPRODUCT(($O$11:$O$17="COMP TIME")*($M$11:$N$17))

Thank you as well! The power of this program truly amazes me and I look forward to learning more about it.

 

[Fluff]

Glad we could help & thanks for the feedback.