LinkBack URL
About LinkBacks
Try
=SUMPRODUCT(--(client!$G$2:$G$30=engineer!D$1)*(client!$F$2:$F$30=engineer!A2))
VBA Noob
Try
=SUMPRODUCT(--(client!$G$2:$G$30=engineer!D$1)*(client!$F$2:$F$30=engineer!A2))
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks