| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Creating a league table based on results
In article ,
gpktm wrote: It not accepts the function in H4 cell. That's probably because your version of Excel uses a semi-colon as a separator instead of a comma. Try... =COUNTIF($B$3:$C$8;G4) And how about the draws? =SUMPRODUCT((($B$3:$B$8=G4)*($D$3:$D$8=$E$3:$E$8)) +(($C$3:$C$8=G4)*($E$3: $E$8=$D$3:$D$8))) Hope this helps! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating single lines of data from a multi-column table | Excel Discussion (Misc queries) | |||
| Creating a list from Table Data | Excel Worksheet Functions | |||
| I am having problems creating pivot table of data | Charts and Charting in Excel | |||
| Creating a Table | Excel Worksheet Functions | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
