wintereabcd
New member
- Sep 9, 2009
- 1
- 0
- 1
...with a condition? Suppose, my Column, A1 to A45 is numbers 1, 2 and 3.
My column B1 to B45 are words like dogs and cats.
I need to total the criteria between A1-A45 and B1 to B45, where dog(Column B) and 1(column A) match or cats and 1 match. Need to total them. What is a formula I could use?
My column B1 to B45 are words like dogs and cats.
I need to total the criteria between A1-A45 and B1 to B45, where dog(Column B) and 1(column A) match or cats and 1 match. Need to total them. What is a formula I could use?