SUM IF & LEFT @cell

Emma_w4tevr

I keep getting the result of 0 

I am trying to sum a range if another column contains "Street Lighting"

I have tried changing the text reference from the entire column, to particular range and adding the LEFT @cell with and without #(5) see below.

=SUMIF(Team:Team, LEFT(="Street Lighting", [Days to respond]2:[Days to respond]4))

=SUMIF(Team6:Team45, LEFT(@cell, 5) = "Street Lighting", [Days to respond]2:[Days to respond]4)

Can someone please advise what I am doing wrong?

Thank you 

SmSulli

I'm not sure exactly what answer you want.  But I can see a few errors in the formula.  The Days to respond rows (rows 2-4) don't line up with the Team rows ( rows 6-45).  And if you want the criteria to be equal to the left 5 letters, then you need to use "Stree" (only 5 letters).

Here's what I thought you were going for.

=SUMIF(Team6:Team45, LEFT(@cell, 5) = "Stree", [Days to respond]6:[Days to respond]45)

Good Luck

Shawn