Need help with adding IF function to existing formula.

[vvthegoodlifevv]

Hi, all,

I'm using: {=SUM(--LEFT(IF(A2:A18="",0,A2:A18),1))}

I would like to add an IF function to this formula so it only sums the left of cells A2:A18 IF cells B2:B18 are "108". Does this make sense?

 

[vvthegoodlifevv]

As you can see, L3 contains the formula, and it returns 0.

 

[vvthegoodlifevv]

Your formula is summing the first character of Col E if col D is 112, which comes to 39.

Right. And the formula does not work for some reason on the pivot table.

 

[Fluff]

and the formula returns only the furthest left digit in the range from E26-E46

That's because you're telling it to.

 

[Fluff]

Right. And the formula does not work for some reason on the pivot table.

I've never used pivots, so wouldn't know.

 

[vvthegoodlifevv]

Anyone else have any suggestions (other than to count them individually myself )?

Thanks in advance.

 

[vvthegoodlifevv]

Boy, these get pushed down reeeeaaal fast. Anyone have any thoughts on this? Thanks in advance.