LinkBack URL
About LinkBacks
All I am trying to do is use a simple sumifs function on a pivot table, but I must be messing something up.
I have attached the document. Sure its a simple mistake I am making.
Thank you!
Trying to use a sumifs function on a pivot table- Thank you for your help
All I am trying to do is use a simple sumifs function on a pivot table, but I must be messing something up.
I have attached the document. Sure its a simple mistake I am making.
Thank you!
No need of Sumif() if the data is arrived from Pivot.
Because Pivot will not output duplicate results and all the relevant data's are accumulated under unique values.
Sumif() can be used when there is any similar data and we need the accumulated value of the data.
So in this case the data came from Pivot source so there is no need of Sumif() and simple Vlookup() with Match() Or Index() with Match function is enough.
=INDEX('Pivot GL Report'!A:K,MATCH(TRIM(B3),'Pivot GL Report'!A:A,0),MATCH(TRIM(C3),'Pivot GL Report'!4:4,0))
Or
=VLOOKUP(TRIM(B3),'Pivot GL Report'!A:K,MATCH(TRIM(C3),'Pivot GL Report'!4:4,0),0)
Since your source data comparison Numbers are in Text so I used Trim() in the above formulas to convert real matching number to text.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Also, sumifs() cannot be used to sum an ARRAY of columns, it can only sum a single column of data
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks