LinkBack URL
About LinkBacks
Pigmul 
Pigmul,
Try
somewhere in Column B on your second sheet, ideally in B4, and copy down - that should do the trick.
=SUMPRODUCT(('Employee Incentive Data'!T:T>0)*('Employee Incentive Data'!B:B=A4))
Pigmul,
Try
somewhere in Column B on your second sheet, ideally in B4, and copy down - that should do the trick.=SUMPRODUCT(('Employee Incentive Data'!T:T>0)*('Employee Incentive Data'!B:B=A4))
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks