Cross Tabulated Table
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQR
1
TableData
2
ExpensesFrom You:
3
CategoryExpense
4
1/1/2012Heating1a) tell me what you are trying to accomplish
5
Category201220131/2/2012Electricity2b) in which cell?
6
6/1/2012Heating1 of which sheet?
7
Heating266/2/2012Electricity2c) show me your expected result
8
Electricity482/2/2013Heating3 along with needed logic/explanation
9
2/3/2013Electricity4
10
3/1/2013Heating3
11
3/2/2013Electricity4a) to produce the sum of expenditures by category by year
12
b) The cells in the range B7:C8
13
c) Sheet1
14
d) My data has twenty categories and I would like to present most of them by quarter over two years
15
RangeE4:E11
16
Criteria2012 and 2013This example is simple in that it is two categories over two years.
17
Sum-RangeG4:G11Real data has ten categories over four quarters each over two years.
18
ACCESS has no problem with that, but I cannot get Google's Sumif() statement even to sum between two dates!
19
I'm looking for sums in B7:C8
20
21
I really miss seeing real Examples in Google's online Help, so be forewarned, I am a novice with Google Spreadsheets.
22
23
Thank you.
24
wem3rd
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1