D
Django Cat
I have a spreadsheet that records units of work completed by a project
team.
Column B records team member names. Column C records the status of each
work unit – ‘pending’, ‘beta’ or ‘completed’.
It’s easy to set up a formula to count how many work units are
allocated to each team member - =COUNTIF(B1:B1000,"Joe"). But what I
need to do is to count how many units Joe has pending, in beta, or
completed. This means setting up formulas which assess data in both
Column B and Column C – and COUNTIF won’t do this.
This doesn’t strike me as an especially uncommon thing to want to do,
and I’d guess the way to do it is quite straightforward, but I haven’t
worked it out yet. Any help from the assembled Excel experts would be
very gratefully received.
DC
--
team.
Column B records team member names. Column C records the status of each
work unit – ‘pending’, ‘beta’ or ‘completed’.
It’s easy to set up a formula to count how many work units are
allocated to each team member - =COUNTIF(B1:B1000,"Joe"). But what I
need to do is to count how many units Joe has pending, in beta, or
completed. This means setting up formulas which assess data in both
Column B and Column C – and COUNTIF won’t do this.
This doesn’t strike me as an especially uncommon thing to want to do,
and I’d guess the way to do it is quite straightforward, but I haven’t
worked it out yet. Any help from the assembled Excel experts would be
very gratefully received.
DC
--