Hi,

You can reference entire columns using J:J type of references. Some
functions do not support these types of references before 2007. You might
also consider range names to make your formula simplier:

If you named column G -- G and column J -- J and V -- V you could
simplify the formula to

=SUMPRODUCT((G="Claims")*(J=C58)*(V=1))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JeffZ88" wrote:

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))