Hello,
How to sum multiplies of 2 columns, but only of their every 4th rows in one formula?
sum.png
I attached file with data.
Hello,
How to sum multiplies of 2 columns, but only of their every 4th rows in one formula?
sum.png
I attached file with data.
Please try
=SUMPRODUCT(A2:A9,D2:D9)
or for more solid
=SUMPRODUCT(A2:A9,D2:D9,--(A2:A9<>""))
=SUMPRODUCT(A2:A9,D2:D9,--(B2:B9<>""))
--(A2:A9<>"") not useful
--(B2:B9<>"") could help if you have a number in A3 and don't want to sum that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks