You REALLY do NOT want to do that. Instead use a dummy row and have
insertions above it or better yet, use defined names for your ranges
insertnamedefinename colG
in the refers to box
=offset($g$1,1,0,counta($a:$a),1)
look in the help index for OFFSET
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JeffZ88" wrote in message
...
this formula works fine. however, I am now looking for a way to include
the
entire columns ($G, $J, and $V), instead of just the short range, as the
source material so people can add rows to their heart's content, without
having to go back an change the formula. Any help would be greatly
appreciated.

=SUMPRODUCT(('Tracking Sheet - Detail Report'!G2:G34="Claims")*('Tracking
Sheet - Detail Report'!J2:J34=C58)*('Tracking Sheet - Detail
Report'!V2:V34=1))