Sumif condition

[Patcheen]

My formula is
=SUMIF(B6:B93,A101,L6:L93)

the condition im looking for is if B6:B93 =B101 then add the numbers from L6:L93 together

but when i do its giving me 0 instead of 1

i surely cant be too far wrong

TIA

 

[AhoyNC]

Shouldn't your criteria be B101 instead of A101.
=SUMIF(B6:B93,B101,L6:L93)

 

[Patcheen]

Yep good spot AboyNC i just spotted that too thank you and sorry everyone for putting up wrong info