If you are using 2007; you can refer this as G:G instead of G2:G65535 but
this will not work in 2003...So better go with the below version...(which is
just 1 row less than the max number of rows in 2003)

=SUMPRODUCT(
('Tracking Sheet - Detail Report'!G2:G65535="Claims")*
('Tracking Sheet - Detail Report'!J2:J65535=C58)*
('Tracking Sheet - Detail Report'!V2:V65535=1))

If this post helps click Yes
---------------
Jacob Skaria


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