corvetteguy
Senior Member
Ok here's my dilema....I have a list ...My problem is i need to count all apples i have(not the sum of the amount of apples) Just how many times the word apples appears in colum A, then i want to see all apples that i have a quantity greater then 0...my though was =countif(b1:b20, ">0")-countif(a1:a20, apples) but this formula gives me the number 18(which would be all the numbers greater then 0, not bothering to check for the word apples in column A) Anyone have any ideas..I know i could do a FILTER and look at only apples in Column A. and change the 1st COUNTIF to B1:b8 and it will give me the right answer but that is a pain if you are constantly updating a list and there are over 2000 rows...Let me know if anyone has any ideas
A B
apples -12
apples 3
apples 0
apples 45
apples 34
apples 12
apples 23
apples 67
bananas 25
bananas 156
bananas 12
bananas 34
oranges 14
oranges 5
oranges 23
oranges 32
peaches 16
peaches 5
peaches 22
peaches 23
A B
apples -12
apples 3
apples 0
apples 45
apples 34
apples 12
apples 23
apples 67
bananas 25
bananas 156
bananas 12
bananas 34
oranges 14
oranges 5
oranges 23
oranges 32
peaches 16
peaches 5
peaches 22
peaches 23