Is this possible?

Giganews Newsgroups
Subject: Is this possible?
Posted by:  Brianas (Brianas.28bxcy_1148503502.909@excelforum-nospam.com)
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:

=SUMPRODUCT(COUNTIF(Schedule!D*143*:D*147*,"=7:00
dir")+(COUNTIF(Schedule!D143:D147,"=8:00
DIR"))+(COUNTIF(Schedule!D143:D147,"=9:00
DIR")+(COUNTIF(Schedule!D143:D147,"=11:00
DIR"))+(COUNTIF(Schedule!D143:D147,"=Mail"))))

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
------------------------------------------------------------------------
Brianas's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34766
View this thread:http://www.excelforum.com/showthread.php?threadid=545272

Replies