Get instant live expert help on I need help with excel n function
“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
I'm trying to get a similar function to work on my excel. =ARRAY_CONSTRAIN(ARRAYFORMULA(index('Contract Month Detail'!$E:$E,match(C6,'Contract Month Detail'!$N:$N,0))), 1, 1)
Solved by S. L. in 28 mins
SUMIF function is not excluding #N/A even though I specified in the function
Solved by T. F. in 28 mins
If function in excel keeps returning #NAME? error. This is my formula =IF(H30="T-int",N/a,needOHappt) Please tell me what I am typing wrong
Solved by B. B. in 15 mins
a sumproduct function is giving me n/a error and I don't know why
Solved by A. W. in 20 mins
I'm working on VLOOK function and still return me #N/A
Solved by O. J. in 22 mins