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.
Bookmarks