H
Harry Flashman
Hi, can anyone help with this please
I have a table that lists articles published over a month.
I have two (relevant) columns:
Column A (Pulications)
The Age
The Age
Sydney Morning Herald
The Age
The Bulletin
The Examiner
(etc - the list runs for hundreds - each represents an article and a
publication may appear more than once)
Column B (Day of the week) [Btw originally the data for this was in
date format, but I am just using the days of the week as text -
because I want to count the days of the week]
Saturday
Saturday
Wednesday
Saturday
Friday
(etc - each represents the day of the week and article appeared, and a
day of the week may appear more than once)
I know how to produce a little table that will tell me how many
Saturdays, Sundays etc.
Column F Column G
Saturday =countif($B:$B,F2)
Sunday =countif($B:$B,F3)
Monday = countif($B:$B,F4)
Now I want to produce a table that lists for each publication how many
articles appeared for each day of the week.
It will have the publications in the first column and the days of the
week in the next 7 columns
Saturday | Sunday | Monday | etc
The Age 23 24 17 etc
The Courier Mail
I hope this is clear.
Is there some simple formula that I can use?
Regards,
Harry
I have a table that lists articles published over a month.
I have two (relevant) columns:
Column A (Pulications)
The Age
The Age
Sydney Morning Herald
The Age
The Bulletin
The Examiner
(etc - the list runs for hundreds - each represents an article and a
publication may appear more than once)
Column B (Day of the week) [Btw originally the data for this was in
date format, but I am just using the days of the week as text -
because I want to count the days of the week]
Saturday
Saturday
Wednesday
Saturday
Friday
(etc - each represents the day of the week and article appeared, and a
day of the week may appear more than once)
I know how to produce a little table that will tell me how many
Saturdays, Sundays etc.
Column F Column G
Saturday =countif($B:$B,F2)
Sunday =countif($B:$B,F3)
Monday = countif($B:$B,F4)
Now I want to produce a table that lists for each publication how many
articles appeared for each day of the week.
It will have the publications in the first column and the days of the
week in the next 7 columns
Saturday | Sunday | Monday | etc
The Age 23 24 17 etc
The Courier Mail
I hope this is clear.
Is there some simple formula that I can use?
Regards,
Harry