Hi,
Need help to plug in Sum if function in to existing GetPivot function, so that the sum functions @ cell range and not on pivot table.
The reason i need this is because i noticed a variance in result when we use GetPivot and sum if requires defined cell range to work. I just need to keep the table dynamic by Get pivot but i what to do it at cell range.
The Formula gives the result for total volume based on multiple criteria.
Thanks!Please Login or Register to view this content.
Bookmarks