Excel help please.

[robert220]

I'm having a hard time figuring out what i need.
I have two sheets one with Raw data, then Results
On results page i have name column then resolved and then Open. I want to have the results look at the name column and search on the Raw data sheet on column G the name column and count how many it shows for that name and also look on the raw data on column B to see how many resolved it has.
sorry it's been awhile since i had to use excel again.
Ive tried the countifs but i can not get it working right.
Thanks in advance.

 

[MARK858]

Do you mean something like the below?

Excel Workbook
	A	B	C	D	E	F	G
1		Resolved					Name
2							Ben
3		Resolved					Ben
4		Resolved					Ben
5							Ben
6							Ben
7							John
8		Resolved					John
9		Resolved					John
10							Andrew
11		Resolved					Andrew
12							Andrew
13		Resolved					Ben
14							Ben
Raw Data

Excel Workbook
	A	B	C
1	Name	Resolved	Open
2	Ben	3	4
3	John	2	1
4	Andrew	1	2
Results

 

[robert220]

Thank you that worked perfect.