I want to change the value inside a shape/textbox based on the sum of values in pivot table. For Example:
A 1
B 3
C 4
A 6
B 2
The text in the red circle will have the value of 7 (sum of all As)
The text in the yellow circle will have the value of 5 (sum of all Bs)
The text in the blue circle will have the value of 6 (sum of all Cs)
In a worksheet cell put :-
=SUMPRODUCT(((A11:A18="A")*(B11:B18)))
Select the shape and put :-
=A9
Where A11:B18 is your data and A9 is the formula cell
Elegant Simplicity............. Not Always
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks