Hi all, hoping someone might be able to assist. I've tried every combination I can think of for Index match and even ifisnumber but no luck.
...
That won't be it by itself. Attach a sample workbook, otherwise we are just guessing....
AliGW Today, 06:08 AMYou're right. One cell is a formula and there isn't a number there all the time....
JBjarnason Yesterday, 09:56 PMEither one or both of the cells you are trying to sum are not really numbers....
AliGW Yesterday, 09:44 PM
Spreadsheets per user (Password Protect)
The First file that ken posted on this thread....
jakmc25 Today, 11:09 AM