Count categories in one column if within particular month

J

Josie

i have a spreadsheet in Excel 2003 which is used as the source data to
produce a pie chart which shows particular categoreis e.g housekeeping,
manual handling occurrences. The data is entered onto the spreadsheet as
occurrences happen. Column A is the date, column l is the category. The
categroy data is transferred onto a table on a new sheet using formulae e.g.
=COUNTIF(Sheet1!$F$2:$F$500,A4) and the data on this table is presented
alongside a pie chart of the data. I want to produce a separate chart for
each month of the year as well as the cumulative total. How do I pick up the
data for a particular month? The data is entered onto the spreadsheet of
source data in date order but the number of entries will vary each month
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign a formula to count items in a column if they are within cor 1
use month in cell date to sum all relevant cells 2
Count Column B if Column A is within a multiple specificed ranges 2
VLookup IF word in string exists within cell, use the word. 0
count the occurance of a particular month in a column of dates 2
Counting Occurrence of a Value within Cells 1
Formula to fill one cell from another 0
Count number of row for Particular month 3

Top