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 strongm 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:
- Thread starter brose99
- Start date
SkipVought
Programmer
hi,
[tt]
=sumproduct((b1:b6="e")*(c1:c6="y"))
[/tt]
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
[tt]
=sumproduct((b1:b6="e")*(c1:c6="y"))
[/tt]
Skip,
[sub]
[red]A palindrome gone wrong?[/red]A man, a plan, a ROOT canal...
PULLEMALL!
[/sub]- Thread starter
- #3
- Status