Penny Bangalore
Board Regular
- Joined
- Apr 17, 2015
- Messages
- 79
Hello,
the below is my data range as table, i want to know the sum of Review and Posted as per the date.. I know i can do with the pivot. but i need a formula to perform this task because i need this to connect this to different workbook with vlookup or index match.
please help
the below is my data range as table, i want to know the sum of Review and Posted as per the date.. I know i can do with the pivot. but i need a formula to perform this task because i need this to connect this to different workbook with vlookup or index match.
please help
Excel 2010 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date | Users | Review | Posted | ||
2 | 5/21/2015 | user1 | 24 | 244 | ||
3 | 5/21/2015 | user2 | 11 | 225 | ||
4 | 5/21/2015 | user3 | 48 | 226 | ||
5 | 5/21/2015 | user4 | 34 | 244 | ||
6 | 5/21/2015 | user5 | 48 | 204 | ||
7 | 5/21/2015 | user6 | 23 | 218 | ||
8 | 5/21/2015 | user7 | 41 | 211 | ||
9 | 5/21/2015 | user8 | 17 | 240 | ||
10 | 5/21/2015 | user9 | 39 | 217 | ||
11 | 5/21/2015 | user10 | 19 | 214 | ||
12 | 5/21/2015 | user11 | 47 | 248 | ||
13 | 5/22/2015 | A | 33 | 208 | ||
14 | 5/22/2015 | b | 27 | 245 | ||
15 | 5/22/2015 | c | 12 | 232 | ||
16 | 5/22/2015 | A | 47 | 223 | ||
17 | 5/22/2015 | b | 16 | 219 | ||
18 | 5/22/2015 | c | 39 | 216 | ||
19 | 5/22/2015 | A | 40 | 218 | ||
20 | 5/22/2015 | b | 48 | 213 | ||
21 | 5/22/2015 | c | 46 | 225 | ||
22 | 5/22/2015 | A | 45 | 203 | ||
23 | 5/22/2015 | b | 50 | 242 | ||
24 | 5/22/2015 | c | 20 | 231 | ||
25 | 5/22/2015 | A | 36 | 223 | ||
26 | 5/22/2015 | b | 36 | 245 | ||
27 | 5/22/2015 | c | 42 | 243 | ||
28 | 5/22/2015 | A | 22 | 214 | ||
29 | 5/22/2015 | b | 19 | 213 | ||
30 | 5/22/2015 | c | 27 | 217 | ||
Sheet2 |