Hi everyone,
I want with vba to calculate the new average from the values of two cells but these values are not "equal weighted".
cell A1
has the : = (23+27+34)/3
cell A2
has the : =(45+23+34+42+36)/5
These are prices that I have entered manually some time ago and I calculated their average ( /3 and /5 )
I need the vba to create in a cell the new average:
= (23+27+34+45+23+34+42+36)/8
Also how do I find (vba?) the number of the prices that exist in these cells ( 3 and 5 numbers) - this is required for calc the average .
Thanks
Alexander
Hope I was clear but English isn't my native language
I want with vba to calculate the new average from the values of two cells but these values are not "equal weighted".
cell A1
has the : = (23+27+34)/3
cell A2
has the : =(45+23+34+42+36)/5
These are prices that I have entered manually some time ago and I calculated their average ( /3 and /5 )
I need the vba to create in a cell the new average:
= (23+27+34+45+23+34+42+36)/8
Also how do I find (vba?) the number of the prices that exist in these cells ( 3 and 5 numbers) - this is required for calc the average .
Thanks
Alexander
Hope I was clear but English isn't my native language