# I'm trying to calculate the values in a column if within a certain range, I am getting 0. Any help?l

Options

=SUM(COLLECT([Total]:[Total], Date:Date, NETDAYS(24 / 1 / 6, 24 / 30 / 6) = 30))

• ✭✭✭✭✭✭
Options

Hello @Ktjohn,

Your syntax for NETDAYS is incorrect, you need to reference actual dates in your arguments rather than text that represents date. See below:

You could nest DATE() functions to correct this portion:

`=SUM(COLLECT([Total]:[Total], Date:Date, NETDAYS(DATE(2024, 6, 1), DATE(24, 6, 30)) = 30))`

I don't suspect this formula will work though based on how COLLECT() functions, I just wanted to show you what I can see is an error.

It's hard for me to recommend a solution without at least a screenshot of your Sheet. If you can provide that and some more info about what you are trying to accomplish I'll do what I can to help.

School of Sheets (Smartsheet Partner)

If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!

• Options

Thanks for your help. Im trying to calculate the sum of a quantity of values if submitted between june 1st 2024 and june 30 2024

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!