Countif:
Is there a way to have a single criteria (a persons name) and multiple ranges
example: a6:a10 c6:c10 and recieve the sum of that criteria and ranges??
I know there is I just cant get it.
I need to count a persons name entered in multiple ranges (cells or areas) on the same worksheet.
I cannot make one big range because i will need to do the same for the b6:b10 but for a different "need"
the a colum and c colum bieng "completed" the b colum bieng "not completed".
I have tried =countif(a6:a10 + c6:c10, cell_with _persons_name) and for obvious reasons that wont work,
Bookmarks