On a pivot table, i have "Years" and "Letters". I don't know how to get subtotals per year.
See attached file, where the red cells are those which should contain data i need.
Anyone can help please ?
Should i rather use vlookup with sums instead ? or do it the hard way with with "if" function ?
In fact, i only need total per year and per letter
A y1 y2 y3 y4
B y1 y2 y3 y4
c Y1 Y2 Y3 Y4
Thanks for your help guys !
JohN
Last edited by Jehan; 03-25-2008 at 06:34 AM.
All that you need is the SUMIF formula
Hi,
=SUMIF(A2:A7;"A";B2:B7) will give you the totals for year 1 for letter "A"
Or pivot table
(see attached)
Last edited by Portuga; 03-25-2008 at 11:31 PM.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
the sumif function works great ... Was finally much more easy than i thought
the sumif function works great ... Was finally much more easy than i thought
the sumif function works great ... Was finally much more easy than i thought
the sumif function works great ... Was finally much more easy than i thought
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks