Excel -formula that excludes names if other colums have info
Closed
SuckatExcel
-
Jun 19, 2015 at 02:11 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 27, 2015 at 12:57 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 27, 2015 at 12:57 AM
Related:
- Excel -formula that excludes names if other colums have info
- Ideogram ai names - Guide
- Excel grade formula - Guide
- My contacts list names - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 25, 2015 at 01:18 AM
Jun 25, 2015 at 01:18 AM
data is like this D1 to F5
6-Jan 2-Jun a
2-Jun s
d
f
g
the formula is
=COUNTA(F1:F5)-COUNTIFS(D1:D5,"",E1:E5,"")
6-Jan 2-Jun a
2-Jun s
d
f
g
the formula is
=COUNTA(F1:F5)-COUNTIFS(D1:D5,"",E1:E5,"")
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 27, 2015 at 12:57 AM
Jun 27, 2015 at 12:57 AM
can you upload a small sample file through speedyshar.com and rephrase the question. I shall try.
Jun 26, 2015 at 12:16 PM
=COUNTIFS(F3:F1436,"=bill*")+COUNTIFS(F3:F1436,"=betty*")
and
=COUNTA(F1:F5)-COUNTIFS(D1:D5,"",E1:E5,"")
I keep getting a "Value" error. :(