Hi all,
Hopefully an easy one.
=SUMPRODUCT(($C:$C="Equity")*($E:$E)*(B:$B))
Essentially want to multiply and sum Column E and B together if C = "Equity"
Columns E and B contain empty cells, which appears to be the root of the problem.
Any ideas?
Thanks,
John
Hopefully an easy one.
=SUMPRODUCT(($C:$C="Equity")*($E:$E)*(B:$B))
Essentially want to multiply and sum Column E and B together if C = "Equity"
Columns E and B contain empty cells, which appears to be the root of the problem.
Any ideas?
Thanks,
John