Several ranges in formula, please advise...

  • Thread starter Thread starter bill
  • Start date Start date
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
 
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
 
Back
Top