| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mod a Formula For Errors
I'm trying to modify this formula so that it does the calculation even if
some of the cells in the ranges do not have "values (N/A or other errors). Thanks you in advance. =SUMPRODUCT(--($C$3:$C$216=I3);--($F$3:$F$2160))/COUNTIF($C$3:$C$216;I3) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mod a Formula For Errors
You can force it to be zero with an if statement like so:
=IF(ISERROR(SUMPRODUCT(--($C$3:$C$216=I3)--($F$3:$F$2160))/COUNTIF($C$3:$C$216,I3)),0,SUMPRODUCT(--($C$3:$C$216=I3)--($F$3:$F$2160))/COUNTIF($C$3:$C$216,I3)) -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "carl" wrote: I'm trying to modify this formula so that it does the calculation even if some of the cells in the ranges do not have "values (N/A or other errors). Thanks you in advance. =SUMPRODUCT(--($C$3:$C$216=I3);--($F$3:$F$2160))/COUNTIF($C$3:$C$216;I3) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Errors | Excel Discussion (Misc queries) | |||
| Formula errors | Excel Worksheet Functions | |||
| Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
| Formula errors | Excel Discussion (Misc queries) | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
Linear Mode
