Hi
I am desperately trying to count a column of items using 2 pieces of
criteria instead of the one used in 'countif' and have tried using 'countif'
and 'And' function nested. i have a column of number which are item numbers
(column A). Column 'B' uses 2 criteria 'Good', 'Bad'. In column 'C' I am
trying to count all item numbers in the column of the same type which are
'Good'. i.e countif(if A1='item type',"Good"). However, counif only allows
one piec of criteria. Can anyone help please?

Thanks in advance
DAT