| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif gone wrong
Hi,
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 this =COUNTIF(Sheet3!A:A,"=2000BC")+COUNTIF(Sheet3!B:B, "=2000BC")+COUNTIF(Sheet3!C:C,"=2000BC")+COUNTIF(S heet3!D: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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| What am I doing wrong? | Excel Discussion (Misc queries) | |||
| something wrong with my "countif" function | Excel Discussion (Misc queries) | |||
| What's wrong with this? | Excel Worksheet Functions | |||
Threaded Mode
