Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
SUMIF condition is met
I have a billing projections sheet that I am trying to figure out how to sum (total) the Current Year to Date billing of a project manager. I have a Project Manager column and Billing CYD column.
Here is the formula I have so far...
=SUMIF([Project Manager], Name of Project Manager, [Billing CYD])
Obviously this does not work but I want the formula to sum only the Billiing CYD cells that have a specific project manager assigned to them. So, for example, if Joy has six projects the formula will look at all six corresponding cells on her row for "Billing CYD". Please help.