Thank you for visiting ITKE.
We are happy to help you with solving specific IT questions, but need as
much information as possible to do so. Let us know about the problem you
are trying to solve, how you are approaching it and what work you’ve
done so far, and we can help guide you in the right direction.
For starters, though, this may help: To count a column of names in a named range called “TheNames” you could use the formula COUNTIF(TheNames,”*”). To count a named range called “LettersSent” that stores dates or blanks use COUNT(LettersSent). It should be easy now to construct a couple of cells that store the values of number of letters sent and number of letters yet to be sent and use these cells as the data for a pie chart