Spreadsheet: 150703d1334664779-sumif-based-on-a-value-in-the-current-sheet-from-multiple-sheets-example-fc-group-v1
Sheet: James

 |  |  |  |  | Emp | Price | April FC units | April FC value
 |  |  |  |  | [NAME] | 3.12 | 10
 |  |  |  |  | [NAME] | 3.12
 |  |  |  |  | [NAME] | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | [NAME] | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | [NAME] | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | [NAME] | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | [NAME] | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | [NAME] | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | [NAME] | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | [NAME] | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | [NAME] | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | All | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | Julie | 3.12
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | [NAME] | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | All | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 2.6676
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | [NAME] | 1.4118
 |  |  |  |  | [NAME] | 1.4118
 |  |  |  |  | [NAME] | 1.4118
 |  |  |  |  | [NAME] | 1.4118
 |  |  |  |  | [NAME] | 1.4118
 |  |  |  |  | [NAME] | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | [NAME] | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | [NAME] | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | [NAME] | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | All | 1.4118
 |  |  |  |  | Julie | 1.4118
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | [NAME] | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | All | 1.287
 |  |  |  |  | Julie | 1.287
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | [NAME] | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | All | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 3.3072
 |  |  |  |  | Julie | 4.1535
 |  |  |  |  | Julie | 4.1535
 |  |  |  |  | Julie | 4.1535
 |  |  |  |  | Julie | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | [NAME] | 4.1535
 |  |  |  |  | [NAME] | 4.1535
 |  |  |  |  | [NAME] | 4.1535
 |  |  |  |  | [NAME] | 4.1535
 |  |  |  |  | [NAME] | 4.1535
 |  |  |  |  | [NAME] | 4.1535
 |  |  |  |  | [NAME] | 4.1535
 |  |  |  |  | Julie | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | [NAME] | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | Julie | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | [NAME] | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | Julie | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | Julie | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | Julie | 4.1535
 |  |  |  |  | Julie | 4.1535
 |  |  |  |  | All | 4.1535
 |  |  |  |  | Julie | 4.1535