Looking to see the Sum based on what is in another column
We are trying to move all of our excel sheets into smartsheets and we have one sales tracking sheet we are looking to have automated. The columns are Salesperson, Month, Expected Sales. What we want to see if Month equals March what is the Sum of the Expected Sales for those Salespersons. We want to have this automated so that as we add people to the list, we only need to add their info, we do not need to update any formulas for the Sum of the Expected Sales - anyone know if this is possible?
Help Article Resources
Check out the Formula Handbook template!