I

#### Isis

A B C D E

2000BC DEF DEF DEF 2000BC

ABC 2000BC DEF 2000BC DEF

2000BC 2000BC 2000BC 2000BC 2000BC

ABC 2000BC DEF DEF DEF

This normally works but Im having a problem with it now. My formula

looks like thi

=COUNTIF(Sheet3!A:A,"=2000BC")+COUNTIF(Sheet3!B:B,"=2000BC")+COUNTIF(Sheet3!C:C,"=2000BC")+COUNTIF(Sheet3!D,"=2000BC")+COUNTIF(Sheet3!E:E,"=2000BC")

The column range is a lot of lines ie reason why I use column:column, the

last countif was added & it returns answer as 0 instead of adding 2 more-if I

change the formula to only read =COUNTIF(Sheet3!E:E,"=2000BC") it gives me a

0.

Is there an alternate formula or is there an error with column thats not

calculating?

thx