LinkBack URL
About LinkBacks
No need to apologise - oversight on my part I think as this requirement is rather self evident!
You could perhaps try
Formula:
D2:
=IF($C2>0,SUM($C2,IFERROR(LOOKUP(2,1/($B$1:$B1=$B2),$D$1:$D1*($A$1:$A1>EDATE($A2,-6))),0)),"")
copied down
No need to apologise - oversight on my part I think as this requirement is rather self evident!
You could perhaps try
Formula:
D2:
=IF($C2>0,SUM($C2,IFERROR(LOOKUP(2,1/($B$1:$B1=$B2),$D$1:$D1*($A$1:$A1>EDATE($A2,-6))),0)),"")
copied down
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
This worked great thanks for all the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks