I am trying to find one name and sum all values in a column; sum would go
into Column G. For instance, I have the employee number in Column A in a
sheet named €˜Filtered List and I want to sum all values in Column E of the
same sheet in the rows where that employee number shows up. The problem is
that the names are not in adjacent rows. I know Sumproduct can overcome this
limitation, but also, I wont know the Employee ID numbers in advance,
because this list is built on the fly, with a macro, so I was hoping to find
a function that I can pop into another simple macro that I have.

Something like this would work:
=SUMPRODUCT((A2:A13=115354)*(E2:E13))

But again, I wont know the Employee ID number in advance, so I cant
necessarily use €˜115354 in my Sumporduct.

Any thoughts?

Thanks,
Ryan---



--
RyGuy