LinkBack URL
About LinkBacks
==SUM((TASKS!K5:K9="IMPL")*(TASKS!I5:I9=50)*TASKS!N5:N9)
Try using =Sumproducts(--(TASKS!K5:K9="IMPL"),--((TASKS!I5:I9=50),TASKS!N5:N9)
==SUM((TASKS!K5:K9="IMPL")*(TASKS!I5:I9=50)*TASKS!N5:N9)
Try using =Sumproducts(--(TASKS!K5:K9="IMPL"),--((TASKS!I5:I9=50),TASKS!N5:N9)
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks