sumproduct

[Guest]

Hi, I am struggling with a sumproduct formula and need some help. Maybe
sumproduct isn't the way to go but I have been trying to sum a set of numbers
in which appear a changing number of times in a worksheet.

Sometimes there are only one and sometimes there are as many as 100+. I am
counting the number of occurences and then multiplying the number of
occurences times the value. I set it up simply below.


Can someone help?

Thanks

=SUMPRODUCT(--($C$7:$C$64>0),$C$7:$C$64,D$7$64)


First Set Second Set

Frequency Value Frequency Value

Column A Column B Column A Column B

1 5 1 5
1 5 2 5
1 5 1 5

=15 =20

 

[Peo Sjoblom]

=SUMPRODUCT(--($C$7:$C$64>0),D$7$64)

will count the number of cells that are greater than zero in C and multiply
with the values in
D?
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Guest]

A Ha. I finally got this. I didn't realize there was another formula which
was duplicating the multiplication.