LinkBack URL
About LinkBacks
Based on your SUMIF you should find the below works:
=SUMPRODUCT(--(tblExeTimes!$B$2:$B$6000>=B1),--(tblExeTimes!$B$2:$B$6000<C1),--(tblExeTimes!$G$2:$G$6000="Nathan"),tblExeTimes!$F$2:$F$6000)
Based on your SUMIF you should find the below works:
=SUMPRODUCT(--(tblExeTimes!$B$2:$B$6000>=B1),--(tblExeTimes!$B$2:$B$6000<C1),--(tblExeTimes!$G$2:$G$6000="Nathan"),tblExeTimes!$F$2:$F$6000)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks