How to use SUMIF with Dates (specifically years) as Range and calculated values as Sum_Range

Peter Hui
Peter Hui โœญโœญ
edited 12/15/20 in Formulas and Functions

Hello everyone!

Good day.

I'm trying to come up with a SUMIF formula where the Range is a collection of Dates (specifically Years) and the Sum_Range consists of calculated values. The criterion is also a calculated value. However, I keep getting the error "Invalid Data Type".

=SUMIF(YEAR({Range 01}), =[Reference Year]2, VALUE({Range 02}))

I checked the data type assignment for each column and aside for the Effective Date in the reference sheet, which is in date format, all the rest are in Text/Number format.

Below are couple of screenshots for reference.

Hope you could help me figure this out.

Thank you.

Screenshot 1.JPG Screenshot 2.JPG


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!