COUNTIF(INDIRECT("Schedule!D"&A1&":D"&B1),"=7:00di r")

etc.

---
HTH

Bob Phillips

(replace xxxx in email address with googlemail if mailing direct)

"Brianas" wrote in
message ...

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...o&userid=34766
View this thread: http://www.excelforum.com/showthread...hreadid=545272