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!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

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