Multiple Criteria Sumifs in Multiple Columns

[rsharma017]

Hello,

I am trying to create a summary total for the department # BC for only the batch type R and P. I have tried multiple sumif functions found in this forum with no luck.



BATCH TYPE DEPT# BATCH TOTAL
P BC $1,949.14
R BC $16,056.32
R BC $42,879.90
M BC $1,686.98
B BS $46,201.65

 

[Jeffrey Mahoney]

Please try:
=SUMIFS($C$2:$C$6,$B$2:$B$6,"BC",$A$2:$A$6,"R")+SUMIFS($C$2:$C$6,$B$2:$B$6,"BC",$A$2:$A$6,"P")