Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Here is my Pivot Table, starting in cell DZ3:
Sum of Time Project Employee J001 : Construct Room With Materials J003 : Buy Materials With Money Frances, Mario 172.75 136 Peris, Sylvain 9 21.25 Smith, Fred 22.5 A1 = "Peris, Sylvain" A2 = "J001 : Construct Room" =GETPIVOTDATA($DZ$3, A1) -- returns total of Sylvain Peris Hours, which is 809.25. =GETPIVOTDATA($DZ$3, A2) -- should return total of project J001 but I get the N/A value. I read all the posts and tried everything. Subtotals of each fields, projects and people are automatic, and I can read the Grand Total in the last column (people total hours) and last line (project total hours) Hope you have a suggestion ! Anik |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Hlookup to return a sum of values | Excel Worksheet Functions | |||
Index to determine total of values | Excel Worksheet Functions | |||
Adding multiple cells, return specific values | Excel Worksheet Functions | |||
How to look up and return multiple values | Excel Worksheet Functions |