| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sumproduct formula
I get to a certain point and I just can't figure stuff out.
I have this formula: =SUMPRODUCT(--(ISNUMBER(-LEFT('Patrol Log'!H10:H13,1)))) This is to count cells that have data beginning with a number, however there is one piece of text that I want included in the sum. "switch". How can I get this text included in the sum? Thank You Brian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Shorten sumproduct formula | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
| SUMPRODUCT using offset from ROW if X marks the spot | Excel Worksheet Functions | |||
Threaded Mode
