| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct and ISTEXT?
I have two continually growing ranges.
I would like to establish how many times there is text in the same location in each range - most of the values are 0. I am guessing I need something like: =sumproduct(--($AP$53:Offset($BG$53,0,0,$A$10), ISTEXT),--($BH$53:Offset($BY$53,0,0,$A$10), ISTEXT)) naturally this won't work. Sandy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If + ISTEXT + SEARCH | Excel Discussion (Misc queries) | |||
| IF-ISTEXT formula | Excel Discussion (Misc queries) | |||
| How to: COUNTIF when ISTEXT is True? | Excel Worksheet Functions | |||
| ISTEXT | Excel Discussion (Misc queries) | |||
| I need help with a =sum IF ISTEXT formula. I keep getting 0. | Excel Discussion (Misc queries) | |||
Threaded Mode
