want to sumdivided instead of sumproduct that contains blanks.

Hi

As you can see in the attached file I have a problem where I have
A column that I need to be able to choose wheter the row is interesting or not.
Two columns that I need to sum up the divided product.

Had it been that I needed to sum the product I could have used a sumproduct. The same for summing up divided products unless as in my case now where I have blank cells, giving me #DIV/0!
Anyone know of any way to work around that problem?

Formula how it looks right now not working: =SUMPRODUCT(N(A:A="a");B:B;1/C:C)

Use this array formula

=SUMPRODUCT(--($A$2:$A$9="a"),IFERROR($B$2:$B$9/$C$2:$C$9,0))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Hi,

Why not use a helper column

Formula:

Please Login or Register  to view this content.

and sum that?