Can I SUMIF with the vlookup cell data?

edited 09/14/23 in Formulas and Functions

I have:

File 1: cell 1 is populated with a number via a vlookup formula in that cell

file 2: I want to sumif the data in file 1, cell 1.

Will SS be able to do that calculation? Will it see the numeric value in the cell or will it give an error as it only sees the formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!