I have created a formula, and altered it many different ways. Every time, it won't give me the correct answer.
The sheet that it is pulling from has the person's name, and what the issue was. So I want to make a formula that will take the whole sheet with everyone's name and their issue, and count the number of times each issue comes up for each person.
Here are a couple of the formula's I've used that aren't working.
Just so you know Main D:D is the column with each person's name in it
D3 in this sheet is the person's name I'm looking to pull info for
Main G:G is the issue
I2 in this sheet is the issue I'm trying to pull for
{=SUM(IF(Main'!$D:$D=$D3,IF(Main'!$G:$G=$I$2,1,0)))}
{=COUNT(IF(Main'!$D:$D=$D3,IF(Main'!$G:$G=$I$2,1,0)))}
and I've done these without being an array.
Please help me I've been trying to get this to work for 5 hours.
The sheet that it is pulling from has the person's name, and what the issue was. So I want to make a formula that will take the whole sheet with everyone's name and their issue, and count the number of times each issue comes up for each person.
Here are a couple of the formula's I've used that aren't working.
Just so you know Main D:D is the column with each person's name in it
D3 in this sheet is the person's name I'm looking to pull info for
Main G:G is the issue
I2 in this sheet is the issue I'm trying to pull for
{=SUM(IF(Main'!$D:$D=$D3,IF(Main'!$G:$G=$I$2,1,0)))}
{=COUNT(IF(Main'!$D:$D=$D3,IF(Main'!$G:$G=$I$2,1,0)))}
and I've done these without being an array.
Please help me I've been trying to get this to work for 5 hours.