I'm using a function:

=SUMPRODUCT(--(A2:A1500="Billy"),--(E2:E1500="1")) to calculate how many times 1 appears for the person 'Billy'

In Column B I input an 'X' when that row is void & shouldn't be counted.

I'm trying to add to the above function that ignores counting rows with an 'X' next to 'Billy' - just count the rows without an 'X' next to 'Billy'

Can anyone provide info in how I'd write that into the existing function.