Please Help

Shaun Bailey

I am trying to use this formula- =IF(CONTACTVALUE({Hardware}) = "Andrew Mattos", [Points Bucket]@row - 10, 0)- Basically I want it to search my TR Project sheet for the Hardware column and if it see's Andrew Mattos contact to subtract 10 points from my point bucket column in my data sheet. It keeps coming back Unparseable.

Paul Newcome

Are you able to provide some screenshots for context?

Shaun Bailey

Here is a dummy version. I need it to -10 when it finds the name in the first sheet.

Paul Newcome

What you would need instead is a COUNTIFS that you would then multiply by 10 which would then be subtracted from your starting total.

=[Points Bucket]@row - (COUNTIFS(……………………) * 10)

Shaun Bailey

Paul do you consult? email me Sbailey@mtu.edu

Shaun Bailey

Paul Newcome

@Shaun Bailey I do consult and have sent you an email. Thank you!