Hi,
You can also use the following array formula (Ctrl+Shift+Enter)
SUM(IF(((B1:B3="F17000")+(C1:C3="F17000"))*(A1:A3= "Out of Warranty"),1))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Mickey" wrote in message
...
I need to be able to count an item if a key word is in a different
columns.
ex: Count the cells that contain "F17000" (Columns B & C) only if it is
"Out
of Warranty" (Column A). Should return the value 2
Column A Column B Column C
Row 1 In Warranty F17000 1085730
Row 2 Out Of Warranty 1085730 F17000
Row 3 Out Of Warranty F17000 1085730
Thanks