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
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!













Related:

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
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,"")
0
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. :(
0
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 27, 2015 at 12:57 AM
can you upload a small sample file through speedyshar.com and rephrase the question. I shall try.
0