Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
BenfordModule.vb
BenfordModuleClass.vb
BenfordTableTennisData.xlsb
CalculateCostsWithInflation.vb
DoubleCalculation.vb
MakeRedAndBlack.vb
Readme.md
SumProductCountAndSum.xlsx

Readme.md

Financial


For the SUMPRODUCT formula in SumProductCountAndSum.xlsx.
It looks like this:


=SUMPRODUCT((B2:B6=C2)*1)
+SUMPRODUCT((B8:B13=C8)*1)
+SUMPRODUCT((B16:B20=C16)*1)


=SUMPRODUCT(((B2:B6=C2)1)(A2:A6=D2))
+SUMPRODUCT(((B8:B13=C8)1)(A8:A13=D8))
+SUMPRODUCT(((B16:B20=C16)1)(A16:A20=D16))


Screenshot is here


Array formula: Which value in array is found in a range?

=INDEX(C1:C6,MATCH(TRUE,COUNTIF(D:D,C1:C6)>0,0))

Screenshot is here

You can’t perform that action at this time.