mercredi 10 juillet 2019

Arrayformula count how many cells in a row are less than cells in another row only if both are nonzero/nonblank

I found this formula, =arrayformula(sumproduct($C$24:$C$31<B$24:B$31)) but I need it to ignore if one or both cells are 0 or blank.

I've tried and, and countifs, but I can't seem to figure it out.

=arrayformula(sumproduct($C$24:$C$31<B$24:B$31))

I want a number 0-8 for counting how many cells in the particular row are less than the compared row, but (i.e. 0<25) needs to be ignored.

Aucun commentaire:

Enregistrer un commentaire