count column d if column b contains.....

[TomRet]

I need to do exactly what the title says. If column b contains a certain name I need the adjacent cells in column d counted

Thanks
Tom

[judgeh59]

have you looked at using either the COUNTIF or COUNTIFS funtions?...a small sample data file would be really helpful also....thanks

[AlKey]

Try this

in A1 and drag formula down

=COUNTIF(D:D,B1)

	A	B	C	D
1	2	Alex		John
2	1	Steve		Alex
3	2	George		Alex
4	1	Nick		Steve
5	2	Jim		George
6				George
7				Nick
8				Jim
9				Jim

[TomRet]

I have looked into them and thought I was doing it right but I get a blank...probably just one thing out of place.

Here is a sample.

Thanks
Tom

[judgeh59]

did you really want to count how many times Steve's name was in column B?....or did you want to SUM all of Steves wage?....I suspect the SUM is what you are looking for.....try this...

Please Login or Register  to view this content.

[TomRet]

Judge that is exactly what I was looking for. evidently I had the whole formula wrong. Thanks so much everyone!

Cheers
Tom

[judgeh59]

no problem....there is a SUMIF that will work also....glad I could and thanks for the rep bump....have a great day....

[AlKey]

I guess it wasn't "exactly what the title says"

[TomRet]

In my mind it was. I wanted to count the contents of column D if Column B contained a certain text, but I certainly won't argue...my mind seldom works properly. Thanks again for all the help, you folks are phenomenal!

Tom