hello. can sOMEONe help me understand this sumproduct formula that looks for duplicates in different columns? Gracias. I don't understand what it doing. What is the need for sumproduct?
=SUMPRODUCT((COUNTIF(A2:A8,B2:B8)=0)*(B2:B8<>""))
hello. can sOMEONe help me understand this sumproduct formula that looks for duplicates in different columns? Gracias. I don't understand what it doing. What is the need for sumproduct?
=SUMPRODUCT((COUNTIF(A2:A8,B2:B8)=0)*(B2:B8<>""))
Sumproduct is here used to sum each B column item, which is not listed in column A, so it is equivalent to
Formula:Please Login or Register to view this content.
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks