| http://www.w3.org/ns/prov#value | - Because the value that we want to return is a number, we can use a simple SUMPRODUCT() formula in C18 cell, like this: =SUMPRODUCT((B3:B13=C16)*(C3:C13=C17)*(D3:D13)) What this does is look on the range B3:B13 for the value on cell C16 and on the range C3:C13 for the value on cell C17 and where it finds both, return the value on column D, from the same row where it found both criteria???s.
|
