Hi All,
I'm trying to make a Sumifs formula where I do not want to sum the array portion. The "InterType" is the array. After I hit the Ctrl+Shift+Enter, the total doesn't match the pivot table I have.
I found info online that an array needs to go in the brackets, but the example I found are putting brackets around just the array. When I do it, it puts bracket around everything. Can someone tell me what I might be doing wrong.
Sample file attached.HTML Code:
Bookmarks