Hi,

Create a pivot table. Drag column B to the row area, column C to the column
area and column B(again) to the data area

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Custard Tart" wrote in message
...
I have a spreadsheet which has a list of tasks in one column and
directly next to it whether that task is complete/not complete/
rescheduled.

For example in cell B2 the task is CL and in column C2 the task is
complete:

B C
2 CL Complete

I would like to add a tally box at the bottom for all CL tasks which
are complete, then another for not complete and another for
rescheduled. At the moment, I can only get it to COUNTIF on either the
CL or the complete value but not both together.

Any help greatly appreciated!