| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional sum with a left function in it
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MID function from right to left | Excel Worksheet Functions | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| left function | Excel Worksheet Functions | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| LEFT function | Excel Worksheet Functions | |||
Threaded Mode
