Bruce T
05-22-2009, 06:40 AM
Need some help with excel. Basically I am trying to use a Countif function to return a value on multiple conditions. i.e.
Column 1 has to meet one of two four letter codes while column 2 has to meet only 1 single letter condition. In simple syntax
If D2:D10000 = MGEN or RIFA and F2:F10000 = U then count them and return numerical value.
Can i use countif or is there a better way? I have tried nesting functions and using database functions but am getting nowhere. Any help appreciated.
Column 1 has to meet one of two four letter codes while column 2 has to meet only 1 single letter condition. In simple syntax
If D2:D10000 = MGEN or RIFA and F2:F10000 = U then count them and return numerical value.
Can i use countif or is there a better way? I have tried nesting functions and using database functions but am getting nowhere. Any help appreciated.