Lost in Excel, looking for formula to look through two range in two rows, whenever there is a number in BOTH in same column multiply them and keep doi

[userwords]

Ive tried with sumproduct not even understanding that it returns booleans. This is my las try:

=SUMPRODUCT(ISNUMBER($C13:$CC13)*ISNUMBER($C$8:$CC$8))

All it does is to count TRUES and multiply or something.

I have a row with a formula returning a number C8:CC8 ONLY when the above rows got a value input, when not they show a #N/A

And another row where i manually input number ONLY IN SOME CELLS C13:CC13
when not they are empty no number no formula.

What i need is a formula that will read through both ranges C8:CC8 and C13:CC13

and whenever it finds a number IN BOTH ROWS AT THE SAME COLUMN

multiply them, do that with each pair it finds, then add all of them


so it must ignore when there is a number only in one of the rows in the same column, either because one is empty or because the other has a #N/A

 

[Jonmo1]

Welcome to the board.

So the #N/A errors will ONLY appear in row 8, not 13 ?

Try this array formula entered wth CTRL + SHIFT + ENTER
=SUM(IF(ISNUMBER($C8:$CC8),$C8:$CC8*$C13:$CC13))

 

[userwords]

Its works thank you. Yep row 8 have some with numbers and some with N/A errors, while row 13 have some with numbers and some empty. And the issue is also that row 8 can have numbers in columns where row 13 is empty in the same column. So only in columns where both row 8 and row 13 have a number it must multiply one for the other, and keep looking for pairs to then add all.

As i was not sure about arrays i did look for doing it with a function and found the sumproduct, but got nothing. I see that using those other functions i usually use like sum and if in a array way are easier in the end.

Unless you see any issue after my last explanation on the requirements, i consider it working.