 # 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