B
Brianas
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**147*,"=7:00
dir")+(COUNTIF(Schedule!D143147,"=8:00
DIR"))+(COUNTIF(Schedule!D143147,"=9:00
DIR")+(COUNTIF(Schedule!D143147,"=11:00
DIR"))+(COUNTIF(Schedule!D143147,"=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**152*,"=7:00 dir"....
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**147*,"=7:00
dir")+(COUNTIF(Schedule!D143147,"=8:00
DIR"))+(COUNTIF(Schedule!D143147,"=9:00
DIR")+(COUNTIF(Schedule!D143147,"=11:00
DIR"))+(COUNTIF(Schedule!D143147,"=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**152*,"=7:00 dir"....