Countif: others?

**DonkeyOte** · 08-11-2009, 08:21 AM

Have you thought of possibly using a Pivot Table(s) for your analysis ? See link in Sig. for general intro.

**ansar** · 08-11-2009, 10:21 AM

Hi thanks for replies again!

Am having a go at the pivot table report, and have inputted row fields and column fields. Would now like program to count numbers for each of the intersecting fields.....
or.....how do i choose a count option for the 'drop data items here' bit of the table?

**DonkeyOte** · 08-11-2009, 10:23 AM

Use one of the fields you used for ROW Field again, you can use a field more than once, once in the DATA Field it's likely to default to Count (if non-numeric data field) - if not simply double click on the field and set to Count rather than Sum.

If in doubt post a sample to reflect where you are and we can show you the missing pieces.

**ansar** · 08-11-2009, 10:56 AM

thanks again: that's worked well.....

**ansar** · 09-02-2009, 08:09 AM

Hello again
I have 2 questions this time:
1) I want to do a simple analysis of the data, but this time by month.
My months have been inputted using the format eg:
26/01/2009
I want to do an analysis by month. Would I use COUNTIF (and if so, how do I input the criteria bit of the formula) or do I use a different formula?

2) I'm doing some similar work on data for different years:
Cutting and pasting of regular charts/ tables seems easy between worksheets: (updating Source Data etc seems easy enough with these charts).
I can't see a way to changing the source data for the pivot tables/ charts which I would like to copy over......
Could you give me some advice?