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.
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.