| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProduct When Range Has Errors
I am using this formula.
=SUMPRODUCT(--($C$3:$C$180=I3);--($F$3:$F$1800))/COUNTIF($C$3:$C$180;I3) Sometimes the ranges have value like: #N/A #VALUE! #NUM! Is there a way to have make the formula "ignore" the cells w/ errors ? Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore errors in range | Excel Worksheet Functions | |||
| New Errors in Sumproduct Usage | Excel Worksheet Functions | |||
| Help on sumproduct returning errors | Excel Worksheet Functions | |||
| Ignoring text and errors with Sumproduct | Excel Worksheet Functions | |||
| sumproduct causing memory errors? | Excel Worksheet Functions | |||
Threaded Mode
