| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignoring text and errors with Sumproduct
I have a ranking formula for numerical values in Column J based on Text
categories in Column A: =SUMPRODUCT(--(A$13:A$2651=A13),--(J13<J$13:J$2651))+1 It doens't work because some of the cells in Column J include error or text values. How can I make this formula work so that it ignores these error/text values? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average of times where text may be in range | Excel Worksheet Functions | |||
| Error setting shape text property | Charts and Charting in Excel | |||
| Combining Text and Date for VLOOKUP | Excel Worksheet Functions | |||
| need a refresher: text boxes on charts that use relational formulas? | Charts and Charting in Excel | |||
| linking text cells | Excel Worksheet Functions | |||
Threaded Mode
