Superstar31
Active Member
- Joined
- Nov 10, 2005
- Messages
- 496
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | ||||||||
2 | ||||||||
3 | ||||||||
4 | LOCATION_CODE | (All) | ||||||
5 | ||||||||
6 | GROSSDEACTS | REPORT_DATE | ||||||
7 | NAME | EMPLOYEE_ID | WKH_DISC_REASON | 9/1/2006 | 9/3/2006 | 9/4/2006 | ||
8 | VariosInfo | 123456 | FN | 4 | ||||
9 | JD | 1 | ||||||
10 | PG | 9 | ||||||
11 | 123456 | 1 | ||||||
12 | VariosInfo | 234567 | DF | 8 | ||||
13 | JD | 4 | ||||||
14 | 234567 | |||||||
15 | VariosInfo | 345678 | PG | 8 | ||||
16 | 345678 | |||||||
17 | VariosInfo | 456789 | FN | 4 | ||||
18 | RY | 6 | ||||||
19 | 456789 | |||||||
20 | 567890 | QW | 1 | |||||
21 | LH | 5 | ||||||
22 | 567890 | |||||||
Sheet1 |
SO thats my data, I would like another cell to count if c8:c5000=FN and if d7=(cell location) then add number is d8:5000
does that makes sense, why can't i figure this out?
i've tried sumif and sum(if
but i give up