| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sumproduct of part cells of a range with blanks
hi all,
please help REF is the name of the range A5:A10, it's items are the following A5=123.a A6=45.b A7=22.b A8=19.a A9=25.a A10 is blank the formula =sumproduct(--left(REF,find(".",REF)-1)) gives an error #VALUE! if any cell of the range is blank. is there a way to solve this problem with many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
| How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions | |||
| summing part of cells in a range | Excel Discussion (Misc queries) | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
Threaded Mode
