SUMIF for Contact Column Properties

Stephanie Bauder

My formula comes back as #No Match but when I filter, I see the results I need. I am hoping you can assist!

I am trying to calculate the amount of time spent for a contact person. Here is the formula I have so far:

=SUMIF([Contract Phase Assigned to]:[Contract Phase Assigned to], "Stephanie Bauder", [Total Time Spent Contract Phase]:[Total Time Spent Contract Phase])

Can you help?

Paul Newcome

Are there multiple contacts in the cells?

Stephanie Bauder

No, It is a single select. I also do not have the column restricted to list values only, not sure if that makes a difference?

Paul Newcome

Make sure the spelling is exactly the same to include the number of spaces in between the first and last name. Even if there are 15 spaces between, SS will only display 1.

Also check to see if that error is present in any cells within either of the columns referenced. It could be that the error is pulling through from somewhere else.