Multiple Arguments

D

dansargeant

I am using this formula =COUNTIF(D6:D11,"K9-3")*1995. I want it to only
return true and multiply by 1995 if E6:E11 also contains "Local" rather
than "Distance". How can I enter the formula so it will check both
arguments?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with Conditional Formating 10
Cell ID help 4
Conditional summing with large amounts of data 1
COUNTIF 8
Copy-Paste while looping 4
How can I write a formula for: cell=+1*number of selections 3
Range 1
If Statement 2

Top