N
nkurucz
I'm using the following:
=SUM(IF($B$11:$B$54=B58,$B$11:$B$54,0))
The problem is, that I am forced to only put a number into the cells. Why
can't I put a number, then a word, then use the "left" function to get rid of
the text and use the number in the sum?
=SUM(IF($B$11:$B$54=B58,$B$11:$B$54,0))
The problem is, that I am forced to only put a number into the cells. Why
can't I put a number, then a word, then use the "left" function to get rid of
the text and use the number in the sum?