I need a productif style function
I entered your fuctions just as you wrote but it still doesn't work, I just
get a #VALUE! error. Also I'm not sure what the -- are for. Thanks for your
help so far.
"Toppers" wrote:
Try something like:
=SUMPRODUCT(--(C1:C10="A"),--(B1:B10),--(D1:D10))
Sum the products of B*D when C="A"
HTH
"Mitch" wrote:
I want to search a range of cells, say C:C for a value, if that value is
there i want to multiply the corresponding B cell and D cell together then
sum up all of the true values. If anyone can help me please let me know.
Thanks
|