Use SUMPRODUCT()

=SUMPRODUCT((D1:D100="Detox")*(E1:E100="Client was admitted"))

etc.
--
Gary''s Student - gsnu200810


"AlexisLovesLife" wrote:

Allright...I tried to work through this using all the other posts as
references, but was unable to make it work for my situation.

I need to be able to "countif" Column D says "Detox" *AND* Column E says
"Client was admitted."

Or when Column D says "Rehab" *AND* Column E says "Client was not admitted."

Any help from anyone!? You guys make this stuff seem so simple! It's
*amazing* to me!

Thanks so much in advance! :)