SUMIFS with multiple criteria evaluating to 0

SJDub

New Member
Joined
Nov 13, 2018
Messages
6
Hey everybody,

I need some help with a workbook that I have to do for school. My SUMIFS keep evaluating to 0. As far as I can tell, I'm following the instructions correctly, but I can't figure out how to fix the problem.

This is my formula

=SUMIFS(Procedures!$B$2:$B$15,Procedures!$C$2:$C$15,"mri",Procedures!$A$2:$A$15,"boyd")

These are the instructions exactly.

"c. Use SUMIFS with an absolute reference to cells B2:B15 on the Procedures sheet for theSum_range. Since the range name includes the column label, you must include the label ineach CriteriaN range.
d. The first criteria range is anabsolute reference to theimage type column on theProcedures sheet. Itscorresponding criteria is mri.
e. The second criteria range isan absolute reference to thetechnician names column onthe Procedures sheet.
f. Type *boyd* for the Criteria2argument. This string meansthat any character(s) canprecede or follow “boyd”


A B C


2 Tech Pat. IT.
3 Boyd 4 CT
4 John 5 MRI
5 Doug 1 Ultra
6 Boyd 6 Dex
7 Mary 5 Ang
8 Joe 2 CT
9 Sara 1 MRI
10 Phil 4 MRI
11 Kate 3 Dex
12 Boyd 2 Ang
13 Doug 2 Ultra
14 Kate 1 CT
15 Sara 2 Ultra

PS Column A is where Tech is located. Hopefully that makes sense for the format.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Hi,

Pay Special attention to instruction f.
 
Upvote 0
You're welcome, glad to help.

Yeah, so you just needed to surround the criteria "boyd" with wildcards, like "*boyd*"
 
Upvote 0

Forum statistics

Threads
1,223,230
Messages
6,170,883
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top