alsexceladmin
Board Regular
- Joined
- Jan 17, 2005
- Messages
- 62
Formula teeth gnasher.xls | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Spreadsheet | Range1 | |||||||||||||
2 | Ben | Site | IndividualSites | IS | JSA-6 | NONE | |||||||||
3 | IS | Crumpsall | Charlestown | 18 | 14 | 14 | |||||||||
4 | JSA-6 | Harpurhey | Crumpsall | 18 | 14 | 14 | |||||||||
5 | NONE | Harpurhey | Harpurhey | 18 | 14 | 14 | |||||||||
6 | |||||||||||||||
7 | Range2 | ||||||||||||||
8 | LADVALUES | IS | JSA-6 | NONE | |||||||||||
9 | Cheetham | 6 | 2 | 2 | |||||||||||
10 | Harpurhey | 6 | 2 | 2 | |||||||||||
11 | Bradford | 6 | 2 | 2 | |||||||||||
12 | |||||||||||||||
13 | Fromabovespreadsheet,howdoIcreateaformulatoproduceanumberedresultinagivencellforthefollowingexample: | ||||||||||||||
14 | Identifyindividualcellcontentof"A3"and"B3"(bothtext)respectively,thenmatchbothcriteriainRange"D2:G5"- | ||||||||||||||
15 | toproducethenumberresultofintersectingcells"E4" | ||||||||||||||
16 | Cellcontentin"A3","B3"comboappliedtoRange1sheetwouldgivearesultof18,similarlywith"A4","B4"combowouldgive14. | ||||||||||||||
17 | IalsoneedtoapplyasimilarformulatoRange2,thenaddthetworesultstogetherinagivencell. | ||||||||||||||
Sheet1 |