Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple COUNT Excel Formula question:

Status
Not open for further replies.

brose99

Technical User
Sep 30, 2005
16
US
Say I have the following:
A B C D E
1 e y
2 lmc n
3 e n
4 ff y
5 e y
6 e n

How do I write a formula in cell D1 that counts how many "e"'s in Column B have a "y" next to them in column C.

TIA
 
hi,
[tt]
=sumproduct((b1:b6="e")*(c1:c6="y"))
[/tt]


Skip,
[sub]
[glasses] [red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![tongue][/sub]
 
That's what I needed!

You da man Skip!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top