N
n8v_nerd
Sorry, let me be a little more clear. I must have been rushing
Anyone that saw my last two posts, knows the breakdown of my workbook
but here it is again. I have a workbook with several worksheets for th
months (January-December), and on for a summary (Reports). I have
cell(A2) in reports where I type the month I want the summary for, an
it uses the indirect function to go grab the info.
Now, I think I might be on the right track, but can't get INDIRECT t
play nice with SUMPRODUCT. The formula below works if on the same page
and without the indirects, but when I replace the cell references wit
the indirect, and stick it on the reports page, it dies and spits bac
#NUM!
=SUMPRODUCT((INDIRECT(A2 & "!B:B")="HS")*(INDIRECT(A2
"!E:E")>0))
Gettin' Frustrated !
Thanks if you can help
Anyone that saw my last two posts, knows the breakdown of my workbook
but here it is again. I have a workbook with several worksheets for th
months (January-December), and on for a summary (Reports). I have
cell(A2) in reports where I type the month I want the summary for, an
it uses the indirect function to go grab the info.
Now, I think I might be on the right track, but can't get INDIRECT t
play nice with SUMPRODUCT. The formula below works if on the same page
and without the indirects, but when I replace the cell references wit
the indirect, and stick it on the reports page, it dies and spits bac
#NUM!
=SUMPRODUCT((INDIRECT(A2 & "!B:B")="HS")*(INDIRECT(A2
"!E:E")>0))
Gettin' Frustrated !Thanks if you can help