Lucas

You can use and array formula for that. Also, the SUMPRODUCT worksheet
function does the same work as an array formula. Array formulas are entered
and editied with Control+Shift+Enter, not just enter. Yours may look like

=SUM(--(A1:A100="critical")*(B1:B100="open"))

For more on array formulas, see
http://www.dicks-blog.com/archives/2...array-formula/
http://www.dicks-blog.com/archives/2...rray-formulas/

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Lucas Soler wrote:
I'd like to count the number of rows that have SEVERITY of "critical"
AND STATUS of "open". I've used COUNTIF to count with only one
condition. Any ideas?

SEVERITY STATUS
critical open
critcal closed