I have a spreadsheet for tracking sales leads. Each row is a lead. One of the columns is called "Status" and the options under this column are limited to a list of 4 options, i.e. Prospect, Proposal, Closed and Dead.
Is there a way for me to easily calculate how many rows have a status of Prospect vs how many have a status of Proposal, etc? I'd like to be able to have a summary at the top of the spreadsheet that shows how many of the leads are in each Status category (i.e. how many prospects vs proposals, etc).
Your input is appreciated!! :)