If/And formula that includes ratios and words

[JRose0303]

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

[Richard Buttrey]

Hi

Perhaps

Please Login or Register  to view this content.