SUMPRODUCT() results in an error

**daddylonglegs** · 11-01-2012, 10:03 AM

I assume COUNTA is no good, Pepe because it will also count error values......on that basis the shortest way I know is to use this formula

=COUNT(1/(A1:A5<>""))

confirmed with CTRL+SHIFT+ENTER

.....but if you want a "normal" formula with SUMPRODUCT try

=SUMPRODUCT(ISNUMBER(MATCH((A1:A5<>"")+0,{1},0))+0)

**BNCOXUK** · 11-01-2012, 10:50 AM

Originally Posted by daddylonglegs

I assume COUNTA is no good, Pepe because it will also count error values......on that basis the shortest way I know is to use this formula

=COUNT(1/(A1:A5<>""))

confirmed with CTRL+SHIFT+ENTER

.....but if you want a "normal" formula with SUMPRODUCT try

=SUMPRODUCT(ISNUMBER(MATCH((A1:A5<>"")+0,{1},0))+0)

Too good to be true. Well learned!