Several ranges in formula, please advise...

Giganews Newsgroups
Subject: Several ranges in formula, please advise...
Posted by:  bill (spamanfire@cox.net)
Date: Fri, 17 Oct 2003

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

Replies