Excel -formula that excludes names if other colums have info [Closed]

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I have a list of 50 names in Column F, I used the Coutif formula to tally the total names in colum Q:5.

ex. =COUNTIFS(F3:F1436,"=bill*")+COUNTIFS(F3:F1436,"=betty*").....and so on.....

I need help with not counting names if Columns E and Columns D have dates entered into them.

For example

Column D has 1 date of 6/1
Column E has 2 dates of 6/2
Column F has 5 names

Using the example above my numerical answer in Q:5 will be 2

I hope you can understand what I'm trying to ask. Making formulas in Excel is really not my strong suite. Thank you!













2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
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,"")
ok...Thank you for your help. I'm still having trouble with the formula. I dont know how to combine the two forumals together.
=COUNTIFS(F3:F1436,"=bill*")+COUNTIFS(F3:F1436,"=betty*")
and
=COUNTA(F1:F5)-COUNTIFS(D1:D5,"",E1:E5,"")

I keep getting a "Value" error. :(
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
can you upload a small sample file through speedyshar.com and rephrase the question. I shall try.