Is this possible?

Giganews Newsgroups
Subject: Is this possible?
Posted by:  Brianas (
Date: Wed, 24 May 2006

I apologize, I'm a rookie at some of this...

I'm struggling to find a way, outside of VB scripting, to have excel
calculate a formula for me.  I have a formula that pulls from a
separate sheet, but I'd also like it to use the current sheet as well.
For example:


I'd love to have just the 143 portion of D143 and just the 147 portion
of D147 taken from a single cell on the current page so that for the
next column I can specify in a different cell 150 and 152 and have
those two values adjust the formula to read.

=SUMPRODUCT(COUNTIF(Schedule!D*150*:D*152*,"=7:00 dir"....

Brianas's Profile:
View this thread: