Sep 30, 2005 #1 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
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
Sep 30, 2005 #2 S SkipVought Programmer Dec 4, 2001 47,487 US hi, [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] Upvote 0 Downvote
hi, [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]
Sep 30, 2005 Thread starter #3 brose99 Technical User Sep 30, 2005 16 US That's what I needed! You da man Skip! Upvote 0 Downvote