Formula to look up a column and paste results in another colum
If your list only has "Dog" or "Dog1" then try:
=IF(OR(D3="Dog",D3="Dog1"),($F$2-COUNTIF($D$3:D3,"dog*")),0)
Otherwise is you have more types of "Dog" then use:
=IF(OR(A3="Dog",A3="Dog1"),($B$2-(COUNTIF($A$3:A3,"dog")+COUNTIF($A$3:A3,"dog1"))), 0)
"DM" wrote:
Is it possible to add a second variable to the formula to also look for
"dog1" at the same time? How do I do that? Something like
=$D$2-COUNTIF($C$3:C3, "dog"; "dog1")
Thank you!
"vezerid" wrote:
I am assuming 100 is in D2 and 99 is in D3. Then the formula for D3 and
down is:
=$D$2-COUNTIF($C$3:C3, "dog")
Alternatively, if you have the words dog, dog1, cat, cat1 etc in D1, E1
etc, you can use the following formula in D3 and copy accross and down:
=$D$2-COUNTIF($C$3:C3, D$1)
HTH
Kostis Vezerides
|