Get instant live expert help on I need help with mixed cell reference

“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

How to I use relative/abs/mixed cell reference if I want to drag down but I want to array to go one the right instead of down
Solved by V. U. in 27 mins
In cell C21, using a SUMIFS function, calculate the total quantity sold (Trans_Sold) per category (Trans_Category) per day (Weekday) in range B20:I26 based on two sets of criteria, C20 and B21. Use an appropriate mixed reference on the criteria cell references to be able to copy the formula through cell I26. Copy the formula through cell range D21:I26.
Solved by Z. S. in 30 mins
I want to reference a cell within a reference cell
Solved by B. J. in 27 mins
When i reference a merged cell from one sheet it wants to reference the range of that cell...i want to only reference the first cell of the merged cell
Solved by K. F. in 12 mins
Enter a function in cell H12, based on the payment and loan details, that calculates the amount of cumulative principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references. Enter a reference to the remaining balance of payment 1 in cell B13. Use the fill handle to copy the functions created in the prior steps down to complete the amortization table.
Solved by S. Q. in 25 mins