Get instant live expert help on sum of an array
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hi , i just wrote an array formula designed to sum up all dates with the day of the month being the 17th, but i keep getting a return of zero with this formula and am not sure why. I evaluated it and saw the array work i.e. it calculated all the days and had 4 return as 17 out of the array list, but for some reason the calculation gives me 0 when it's all said and done.
Cell Array Formula : {=SUM((DAY(B1:B11)=17))}
Solved by E. Y. in 18 mins
i have array of two columns which i need to multiply and then sum of the product subject to if a value in 3rd column falls in a specified range so for eg
A1= 5
B1= 10
C1=5
So if C1 lies between 0-5 then multiply A1*B1 and does this for an array of all values in A1 & B1 and them sum the values
Solved by V. F. in 30 mins
HI
Need help to vind val in left col then horiz to cell value
do this for an array and sum found values in total val cell
a 5.00
b 10.00
c 15.00
d 20.00
b 25.00
sum
Solved by M. H. in 13 mins
I need to sum multiple columns with multiple rows based on criteria. I'm currently using a SumIf with offset formula. However, instead of returning the sum with the 12 columns I intend, it's only returning the sum of the first column in the array. Please help!
Solved by X. C. in 18 mins
I need a formula that can reveal repeated values in an array of data
Solved by G. A. in 17 mins