Summing in an array

  • Thread starter Thread starter ASPENCO
  • Start date Start date
A

ASPENCO

I would like to write an array formula that sums a column based upon th
values in another column but in addition to just providing a sum i
then needs to perform another mathematical function. For example:

10 $100
50 $1000
40 $500


Given the above data I would like to create a formula that adds th
dollar values in the second column if the value in the first column i
greater than 30 but in addition to adding those values it multiplie
each of the dollar figures by 25% of the value in the first column s
that the value for this proposed formula would be (.25*50*1000)
(.25*40*500). Thanks
 
I believe that Frank misread the question !

Try this:

=SUMPRODUCT((A1:A10>30)*(B1:B10)*(A1:A10)*0.25)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi
try
=SUMIF(A1:A100,">30",B1:B100)*25

Frank
 
Back
Top