Given you're using XL2007 you can use SUMIFS function (not available pre XL2007)
A2: =SUMIFS(Sum,Account,B2,Type,C2)
Given you're using XL2007 you can use SUMIFS function (not available pre XL2007)
A2: =SUMIFS(Sum,Account,B2,Type,C2)
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)
Bookmarks