What I need is a formula for the following:
If Column A equals "No Show" and Column B equals "Anthem" then sum of cell C2 divided by D2

Every time I input this simple little formula I get an error. Your help is immensely appreciated!


A B C D
Status Coverage Counts No Shows
No Show Anthem 5 10