Hi there. I'm sure I'm not the first person to want to do this, but I am having trouble wording a query in qoogle or on this forum to find the answer to this question...
Say i was using a spreadsheet to track a number of projects and their phases:
PROJECT.........................PHASE
project one.....................initiation
project two.....................planning
project three..................initiation
project four....................execution
project five....................execution
i want to have a formula at the bottom that sums the "phase" column like so:
Initiation.....2
Planning.....1
Execution....2
How would i accomplish this? (not including the dots)![]()
Thanks,
Caltrop
Bookmarks