Get instant live expert help on I need help with excel range formula

“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

I want to show excel formula in different range
Solved by O. Y. in 18 mins
I need an "if" formula in excel to use range that I had got in another cells as text using a "cell address" formula
Solved by F. F. in 23 mins
I need a formula for excel that counts the number of rows that have a created date range for each month of the year
Solved by C. H. in 11 mins
hi there, I'm trying to use a named range in a camera object. E.g a camera picture, rather than having x1 cell reference is referring to a named range. When I attempt to enter the named range in the formula bar, it says it is not a valid input. I'm using excel 2016. The named range is itself an indirect formula =INDIRECT(CHOOSE('Dynamic Charts - 2'!D15,"'Dynamic Charts - 2'!$D$7","'Dynamic Charts - 2'!$D$8"))
Solved by G. S. in 20 mins
I Am using a Sumifs formula , so i have created for date range with 2,3 cell, but when i am adding new name the formula have to copy and special paste (value), now i want to auto update the cell value with formula cell refernce. formula is =Sumifs('A'!B:B,'A'!A:A,">="&B3,'A'!A:A,"<="&C3) SUMIFS(CELL NAME RANGE,CELL VALUE,CELL NAME RANGE DATE RANGE)
Solved by G. L. in 21 mins