Several ranges in formula, please advise...

B

bill

Ive got different ranges that I have applied a conditional formula to, and
Im not sure how to correctly add these to the formula..Please help if you
can..
=COUNTIF(G3:M31,"Jan")

why can't I select all my ranges of cells and then define them with a name,
and just insert the name where the "G3:M31" is? Thanks for your help..Bill
 
B

Bernard Liengme

I defined a name that covered two non-contiguous ranges - Mydata.
These formulas worked SUM(Mydata), MAX(MyData);
these did not (VALUE error) COUNTIF(Mydata,3) and SUMPRODUCT(--(MYdata=3)).
So I guess you are left with =COUNTIF(rng1,"Jan") + COUNTIF(rng2,"Jan").....

Bernard
 
Top