Count a row with two conditions
Closed
Hefcat
-
Dec 17, 2009 at 03:18 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 17, 2009 at 08:14 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 17, 2009 at 08:14 PM
Related:
- Count a row with two conditions
- Saints row 2 cheats - Guide
- How to delete row in word - Guide
- Youtube subscriber count - Guide
- How to count names in excel - Guide
- How to convert row to column in notepad++ ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 17, 2009 at 08:14 PM
Dec 17, 2009 at 08:14 PM
try this formula
=SUMPRODUCT(($A$2:$A$10000="D1")*($B$2:$B$10000="1/1/2009"+0))
If the no. of rows is not more than 10,000.
the actual data starts from second row with row 1 having headings.
for separating Ds and Ns just sort the data.
=SUMPRODUCT(($A$2:$A$10000="D1")*($B$2:$B$10000="1/1/2009"+0))
If the no. of rows is not more than 10,000.
the actual data starts from second row with row 1 having headings.
for separating Ds and Ns just sort the data.
