M
Mike
It's a bit difficult to come up with a solution based only
on your explaination of what you need. Please provide
some realistic samples of your data. Include sheet names,
what is contained in each relevant column and row for each
sheet, and what you expect the combined data to look
like. It may very well be possible to achieve your goal
with only a few worksheet functions.
For example, if column A has the date, column B has the
type of query (coded Q1, Q2, Q3, or something along this
line), column C is the customer name, and D is the
resolution, and you simply want the total count of query
type Q1, the formula would be:
=COUNTIF(B:B,"Q1")
But since you say you want a count by day on a seperate
sheet, you might have column A showing one day per row,
with row 1 showing query types like this:
Q1 Q2 Q2
7/1/3
7/2/3
7/3/3
..
..
7/23/3
In which case this formula entered in B2 (intersection of
7/1/3 and Q1) and filled down and across may work for you.
=SUMPRODUCT((Sheet1!$B$1:$B$100=B$1)*(Sheet1!
$A$1:$A$100=$A2))
on your explaination of what you need. Please provide
some realistic samples of your data. Include sheet names,
what is contained in each relevant column and row for each
sheet, and what you expect the combined data to look
like. It may very well be possible to achieve your goal
with only a few worksheet functions.
For example, if column A has the date, column B has the
type of query (coded Q1, Q2, Q3, or something along this
line), column C is the customer name, and D is the
resolution, and you simply want the total count of query
type Q1, the formula would be:
=COUNTIF(B:B,"Q1")
But since you say you want a count by day on a seperate
sheet, you might have column A showing one day per row,
with row 1 showing query types like this:
Q1 Q2 Q2
7/1/3
7/2/3
7/3/3
..
..
7/23/3
In which case this formula entered in B2 (intersection of
7/1/3 and Q1) and filled down and across may work for you.
=SUMPRODUCT((Sheet1!$B$1:$B$100=B$1)*(Sheet1!
$A$1:$A$100=$A2))