Still Not working, for some reason I am getting #N/A

Does it matter if one of the selecting Columns is derived? by that I mean
the following,

=SUMPRODUCT((Team="Dev")*(Sprint!G3:G365="Pending" )*(Sprint!J3:J365))

Where "Pending" G3:G365, is determined by a formula. it could be complete or
in progress.
--
Jeff


"D Hilberg" wrote:

=SUMPRODUCT((a1:a99="Bob")*(c1:c99="pending")*(b1: b99))

but use your own row ranges, of course.

- DH