Count 2 values in one column and 1 val in oth
Solved/Closed
JJ
-
Mar 31, 2010 at 04:20 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 1, 2010 at 10:28 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 1, 2010 at 10:28 PM
Related:
- Count 2 values in one column and 1 val in oth
- Tentacle locker 2 - Download - Adult games
- Fnaf 1 download pc - Download - Horror
- Gta 1 download - Download - Action and adventure
- Five nights in anime 2 - Download - Adult games
- Five nights in anime 1 - Download - Adult games
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 1, 2010 at 10:28 PM
Apr 1, 2010 at 10:28 PM
suppose sample data is like this (row 1 has headings H1 and H2)
H1 H2
A YES
B YES
C
B YES
B YES
A
C YES
try this formula in an empty cell
=SUMPRODUCT((A2:A8="B")*(B2:B8="yes"))
you will get 3
H1 H2
A YES
B YES
C
B YES
B YES
A
C YES
try this formula in an empty cell
=SUMPRODUCT((A2:A8="B")*(B2:B8="yes"))
you will get 3
