Formula for adding all figures associated to a specific date


Good Day,

I would like to add up all the "Cost Price KES" amounts associated to a specific "Delivery Date".

I am trying with the current formula =SUMIF([Cost Price KES]5:[Cost Price KES]652, [Delivery Date]5:[Delivery Date]652 = 4 / 1 / 22) which is not working.

Can someone please assist me??

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!