tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715312d1611662461-dropdown-to-populate-b3-b6-when-an-alphabet-is-selected-in-a3-a6-dropdown_linkcell_sample_2
Sheet: Names

Last Name | First Name | Name |  | Let | Name
Abdelnour | Habig |  |  |  | Abdelnour, [NAME]
Abdelrahman | Habiger |  |  |  | Abdelrahman, Habiger
Macchi | Hable |  |  |  | Abdou, Hachey
Macchia | Haby |  |  |  | [NAME], [NAME]
Macchio | Hach |  |  |  | Abdulla, [NAME]
Macchione | Hache |  |  |  | [NAME], [NAME]
Abdou | Hachey |  |  |  | [NAME], Fager
Abdul | Faga |  |  |  | [NAME], [NAME]
Abdulla | Fagan |  |  |  | Abed, [NAME]
[NAME] | Fagen |  |  |  | Abee, Yanagi
[NAME] | Fager |  |  |  | [NAME], [NAME]
[NAME] | Yampolsky |  |  |  | Abeles, [NAME]
Abed | Yan |  |  |  | Abell, Fago
Abee | Yanagi |  |  |  | Abella, Faaborg
[NAME] | Yanak |  |  |  | Macchi, Hable
Sabio | Faggart |  |  |  | Macchia, [NAME]
[NAME] | Fagin |  |  |  | Macchio, Hach
Sabiston | Yanke |  |  |  | Macchione, Hache
Sablan | Yankee |  |  |  | Sabio, Faggart
Sable | Yankey |  |  |  | Sabir, Fagin
Abeles | [NAME] |  |  |  | Sabiston, Yanke
Abell | Fago |  |  |  | Sablan, Yankee
Abella | Faaborg |  |  |  | Sable, Yankey
Spreadsheet: 18cc4e1e-97e0-4cbb-8335-21f5b1f69df6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | Departmental Summary
 | Faculty #s |  |  |  |  | Research |  | Education |  |  |  | Publications
Department | FT Prof. | FT Assoc. | FT Asst. | FT Instr. | Pt. Time | # Grants | $ [NAME]* | % Med. [NAME]. | % GME | % [NAME]. | % CME | Peer Rev. | Invited | Books**
Community Med & Health Care | 6 | 6 | 7 | 0 | 8 | 7 | 3536980 | 0.09 | 0.012 | 0.156 | 0.012 | 47 | 11 | 20
*Direct costs only
**Includes chapters
Spreadsheet: 768923d1645201972-vertical-and-horizontal-look-up-and-sum-inquiry-formula-help
Sheet: Sheet1

 | 2021-12-13 00:00:00 |  |  |  |  |  |  |  |  |  | <--- these change with each new project so you may have 1 Dec and 5 Jan
Person 1 | 20 |  |  | 20 |  |  | 20 |  | 30
Person 2 | 20 |  |  | 20 |  |  | 20 |  | 30
Person 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Person 4 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 40 | 40
 | Dec | Jan | Feb
Person 1
Person 2
Person 3
Person 4
Expected Result
 | Dec | Jan | Feb
Person 1 | 20 | 40 | 30
Person 2 | 20 | 40 | 30
Person 3 | 9 | 15 | 6
Person 4 | 96 | 160 | 80
Spreadsheet: 701967d1604019177-drop-down-list-choose-multiple-choices-rma-log-2021
Sheet: Sheet1

Status | Initials | [NAME] | RMA# | Customer | Item | Code | Location | Reason | Notes | Received Date | Refund Approval or Replaced | Credit Memo | Inv Adj # | Original Invoice Date | Warranty | Original SO# | Original PO# | RTS
PENDING | dep | 2020-10-02 00:00:00 | 2020-10-01 00:00:00 | NATIONAL VISION INC | ONS-HARLYN2.0-193P | **DEFECT** | LENS - RIGHT | DELAMINATION |  | 2020-10-29 00:00:00 |  |  |  | 2020-06-01 00:00:00
Spreadsheet: 725490d1616693933-daily-sales-spreadsheet-month-target-2021-22
Sheet: 2021 QTR2

Monthly Target | 2021-07-01 00:00:00 |  |  |  |  |  |  | Monthly Target | 2021-08-01 00:00:00 |  |  |  |  |  | 2021-09-01 00:00:00
31150 |  |  |  |  |  |  |  | 31150
Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  |  | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | DATE | Daily Target | Daily Sales | Month To Date | Updated Target
 |  |  | 2491 |  |  |  |  |  |  |  | 2491 |  |  |  |  |  | 2491
 |  |  | 2553 |  |  |  |  |  |  |  | 2553 |  |  |  |  |  | 2553
 |  | Target
 |  |  |  |  |  |  |  |  |  | Target |  |  |  |  |  | Target
TOTAL |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 752980d1635172380-formula-to-get-unique-list-of-values-from-multiple-columns-in-a-table-fx-to-get-unique-list-from-multi-cols4
Sheet: Sheet2

 | Planned |  |  | Expected
 | Milestone Master List | Due Date |  | Milestones | Due Date | Dependent MSs  comma-delimited | 1 | 2 | 3 | 1 | 2 | 3
 | MS_1 | 2022-10-24 00:00:00 |  | MS_1 |  | MS_2, MS_3, MS_4 |  | MS_3 | MS_4 | 2022-05-31 00:00:00 |  | 2022-12-24 00:00:00
 | MS_2 | 2022-10-01 00:00:00 |  | MS_5 | 2022-10-24 00:00:00 | MS_6 |  |  |  | 2023-05-31 00:00:00
 | MS_3 | 2022-10-01 00:00:00 |  | MS_7 | 2022-05-03 00:00:00 | MS_8, MS_9, MS_10 |  | MS_9 | MS_10 |  | 2022-04-17 00:00:00
 | MS_4 | 2022-10-01 00:00:00 |  | MS_11 | 2022-07-01 00:00:00 | MS_12
 | MS_5 | 2022-10-24 00:00:00 |  | MS_13 | 2022-04-19 00:00:00 | MS_14 |  |  |  | 2022-06-17 00:00:00
 | MS_6 | 2022-09-01 00:00:00
 | MS_7 | 2022-05-03 00:00:00
 | MS_8 | 2022-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | Desired List
 | MS_9 | 2022-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  | MS_4 | 2022-12-24 00:00:00
 | MS_10 | 2022-04-30 00:00:00 |  |  |  |  | MS_3 |  |  | 2022-12-24 00:00:00 |  |  | MS_6 | 2023-05-31 00:00:00
 | MS_11 | 2022-07-01 00:00:00 |  |  |  |  | MS_4 |  |  | 2023-05-31 00:00:00 |  |  | MS_14 | 2022-06-17 00:00:00
 | MS_12 | 2022-06-01 00:00:00 |  |  |  |  | MS_6 |  |  | 2022-04-17 00:00:00
 | MS_13 | 2022-04-19 00:00:00 |  |  |  |  | MS_8 |  |  | 2022-06-17 00:00:00
 | MS_14 | 2022-01-01 00:00:00 |  |  |  |  | MS_9
 |  |  |  |  |  |  | MS_10
 |  |  |  |  |  |  | MS_12
 |  |  |  |  |  |  | MS_14
Spreadsheet: joe_parks__14620__POSTIONTRAX_NOV
Sheet: HSC_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 38.5 | 2.11 |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  |  |  |  |  |  |  |  |  | 230000
 |  |  |  |  |  |  |  |  |  |  | -366780
 |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | -5.5
 |  |  |  |  |  |  |  |  |  |  | 12.5
 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 114707d1310441743-excel-2007-excel-trend-and-bar-help-excel-template-with-trend
Sheet:    Income Statement   

Income Statement Dashboard
5-yr trend |  | 2003 |  | 2004 |  | 2005 |  | 2006 |  | 2007 |  | 5-yr TOTAL
 | Revenue | 163391 |  | 147956 |  | 134291 |  | 113421 |  | 132226
 | Cost of Revenue / COGS | 93396 |  | 81916 |  | 73375 |  | 61665 |  | 63007
 | Gross Profit | 67458 |  | 64357 |  | 59852 |  | 51154 |  | 68206
 | Selling Expenses | 7053 |  | 7215 |  | 6974 |  | 6821 |  | 20692
 | Marketing Expenses | 7053 |  | 7215 |  | 6974 |  | 6821 |  | 20692
 | Administrative Expenses | 7053 |  | 7215 |  | 6974 |  | 6821 |  | 20692
 | Research & Development | 777 |  | 0 |  | 0 |  | 0 |  | 0
 | Depreciation/Amortization | 777 |  | 0 |  | 0 |  | 0 |  | 0
 | Interest Expenses | 66666 |  | 986 |  | 728 |  | 308 |  | 326
 | Other Operating Expenses | 37414 |  | 35143 |  | 32917 |  | 26480 |  | 29229
 | Operating Income | 24620 |  | 22696 |  | 20297 |  | 18147 |  | 18972
 | Interest Income (Expense), Non-Oper. | 555 |  | 22222 |  | 0 |  | 0 |  | 0
 | Gain (Loss) on Sale of Assets | 222 |  | 34 |  | 0 |  | 0 |  | 0
 | Other | 777 |  | 0 |  | 0 |  | 0 |  | 0
 | Income Before Tax | 24620 |  | 22696 |  | 20297 |  | 18147 |  | 18972
 | Income Tax - Total | 3954 |  | 4035 |  | 3696 |  | 4056 |  | 3790
 | Income After Tax | 20666 |  | 18661 |  | 16601 |  | 14091 |  | 15182
Spreadsheet: michelle_cash__26512__M Cash_Individuals
Sheet: Combined Search Result List

Enron Corp
Individuals
 |  | (yes or no)
 | Individuals | Enron Employee | Dates of Employment
1 | [NAME], Sr.
2 | [NAME]
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME] and [NAME]
8 | [NAME]
9 | [NAME] |  |  | No record in SAP
10 | [NAME] |  |  | No record in SAP
11 | [NAME] | Yes | 8/1/90 - 9/15/01
12 | [NAME] | Yes | 9/8/94 - 8/1/01
13 | [NAME] | Yes | 12/3/90 - LOA 10/24/01
14 | [NAME] |  |  | No record in SAP
15 | [NAME] | Yes | 10/25/93 - Current
16 | [NAME] | Yes | 1/23/95 - Current
17 | [NAME] | Yes | 9/3/96 - Current
18 | [NAME] |  |  | No record in SAP
19 | [NAME] |  |  | No record in SAP
20 | [NAME] | Yes | 9/6/87 - Current
21 | Rodger W.P. Yeomans |  |  | No record in SAP
22 | [NAME] |  |  | No record in SAP
23 | [NAME] |  |  | No record in SAP
24 | [NAME] |  |  | No record in SAP
25 | [NAME] |  |  | No record in SAP
26 | [NAME] |  |  | No record in SAP
27 | Little Joe |  |  | No record in SAP
28 | [NAME] |  |  | No record in SAP
29 | [NAME] |  |  | No record in SAP
Spreadsheet: 80662d1280869295-conditional-formatting-mockup-df
Sheet: Sheet1

 | Tracking ID | Date  Assigned | Subject | Date  Due | Date  Closed | Days in Progress
1 | aaa | 2010-07-05 00:00:00 | A | 2010-07-09 00:00:00 | 2010-07-08 00:00:00 | 3
2 | bbb | 2010-07-06 00:00:00 | B | 2010-07-10 00:00:00 | 2010-07-11 00:00:00 | 3
3 | [NAME] | 2010-07-07 00:00:00 | C | 2010-07-11 00:00:00 | 2010-07-07 00:00:00 | 0
4 | ddd | 2010-07-08 00:00:00 | D | 2010-07-12 00:00:00 | 2010-07-13 00:00:00 | 3
5 | eee | 2010-07-09 00:00:00 | E | 2010-07-13 00:00:00 | 2010-07-13 00:00:00 | 2
6 | [NAME] | 2010-08-03 00:00:00 | F | 2010-08-09 00:00:00
7 | ggg | 2010-08-03 00:00:00 | G | 2010-08-09 00:00:00
8 | hhh | 2010-08-03 00:00:00 | H | 2010-08-09 00:00:00 | 2010-08-03 00:00:00 | 0
9
10
 | As you can see, I would like a function that would determine for me which cases are in progress and highlight them.
 | I can't do a simple IFBLANK on column F because in my original document, there are cells below which are blank awaiting new cases (like 9, 10 here).  These should not be highlighted obviously.
 | My thinking was that I needed a formula that would activate the formatting if 'F' is blank, YET 'C' is not.  In my mind this would get me what I want.
 | Is this making sense to anyone?
Spreadsheet: 123587d1317743421-displaying-different-data-depending-on-what-is-clicked-or-selected-example
Sheet: Sheet1

2011-10-04 00:00:00
Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose
2011-10-04 00:00:00
Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose
2011-10-04 00:00:00
Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose
2011-10-04 00:00:00
Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose | Choose
 |  |  | REPORTING: Example only!!!
 |  |  | Type the Date to Report:
 |  |  | [NAME]: ##/##/##
 | Total Daily Errors |  |  |  | Total Daily Warnings |  |  |  | Total Daily Running
 | Total Daily Fail |  |  |  | Total Daily No Email |  |  |  | Total Daily Success
Spreadsheet: 158132d1337992837-solved-parse-and-make-sense-of-data-formula-assistance-151_example-1-
Sheet: Worksheet 1

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
player ID | Name | Play Date | Total At-Bats | Single | Double | Triple | Home Run | Base On Error | Strike Out | Fly Out | Ground Out | Line Out | Sac. Bunt | Sac. Fly | Walk | [NAME] | [NAME] Out | Hit By Pitch | [NAME] In | Fielders Choice | Run Scored
8 |  | 2012-03-21 00:00:00
13 |  | 2012-03-21 00:00:00
14 |  | 2012-03-21 00:00:00
15 |  | 2012-03-21 00:00:00
16 |  | 2012-03-21 00:00:00
17 |  | 2012-03-21 00:00:00
18 |  | 2012-03-21 00:00:00
19 |  | 2012-03-21 00:00:00
20 |  | 2012-03-21 00:00:00
21 |  | 2012-03-21 00:00:00
22 |  | 2012-03-21 00:00:00
23 |  | 2012-03-21 00:00:00
8 |  | 2012-03-24 00:00:00
13 |  | 2012-03-24 00:00:00
14 |  | 2012-03-24 00:00:00
15 |  | 2012-03-24 00:00:00
16 |  | 2012-03-24 00:00:00
17 |  | 2012-03-24 00:00:00
18 |  | 2012-03-24 00:00:00
19 |  | 2012-03-24 00:00:00
20 |  | 2012-03-24 00:00:00
21 |  | 2012-03-24 00:00:00
22 |  | 2012-03-24 00:00:00
23 |  | 2012-03-24 00:00:00
8 |  | 2012-03-28 00:00:00
13 |  | 2012-03-28 00:00:00
14 |  | 2012-03-28 00:00:00
15 |  | 2012-03-28 00:00:00
16 |  | 2012-03-28 00:00:00
17 |  | 2012-03-28 00:00:00
18 |  | 2012-03-28 00:00:00
19 |  | 2012-03-28 00:00:00
20 |  | 2012-03-28 00:00:00
21 |  | 2012-03-28 00:00:00
22 |  | 2012-03-28 00:00:00
23 |  | 2012-03-28 00:00:00
Spreadsheet: 110454d1307106525-adjusting-coding-for-new-criteria-workbook41
Sheet: Sheet1

DOUBLE |  | 9115
 |  | 9116 |  |  |  | Highlighted are the numbers NOT picked up - what would the coding revision need to be to do this?  I'm wanting to pickup any multiple of numbers (2 or more).
 |  | 9117
 |  | 9118
 |  | 9119
 |  | 9123
 |  | 9125
 |  | 9126
 |  | 9127
 |  | 9128
 |  | 9129
 |  | 9132
 |  | 9133
 |  | 9135
 |  | 9136
 |  | 9137
 |  | 9138
 |  | 9139
 |  | 9142
 |  | 9143
 |  | 9145
 |  | 9146
 |  | 9147
 |  | 9148
 |  | 9149
 |  | 9152
 |  | 9155
 |  | 9156
 |  | 9157
 |  | 9158
 |  | 9159
 |  | 9162
 |  | 9166
 |  | 9167
 |  | 9168
 |  | 9169
 |  | 9177
 |  | 9333
 |  | 9335
 |  | 9336
 |  | 9337
 |  | 9338
 |  | 9339
 |  | 9343
 |  | 9345
 |  | 9346
 |  | 9347
 |  | 9348
 |  | 9349
Spreadsheet: benjamin_rogers__905__ny prices 09_17_01
Sheet: Oct DA

 |  |  |  |  |  |  |  |  |  |  | 16 Hr Avg |  |  |  | Price |  |  |  | Price |  |  |  | Price
 |  | Day Ahead Prices |  |  |  |  |  |  |  |  | NYISO |  | Zone A |  | Forecast |  | Zone G |  | Forecast |  | Zone G |  | Forecast
Date |  | Zone A | % | Zone G | % | Zone J | % | PJM | % |  | Load |  | Average |  | Zone A |  | Average |  | Zone G |  | Average |  | Zone J
2001-09-29 00:00:00 |  | 27.62 |  | 30.88 |  | 31.24 |  | 20.43 |  |  | 17413
2001-09-30 00:00:00 |  | 24.57 |  | 29.41 |  | 29.31 |  | 18.52 |  |  | 17160
2001-10-01 00:00:00 |  | 26 |  | 30.45 |  | 31.09 |  | 24.89 |  |  | 19598
 |  | 26.29 |  | 30.64 |  | 32.83 |  | 24.77 |  |  | 20010
 |  | 26.85 |  | 28.76 |  | 30.24 |  | 29.84 |  |  | 20719
 |  | 27.33 |  | 31.66 |  | 33.67 |  | 29.87 |  |  | 21426
 |  | 26.83 |  | 30.86 |  | 32.61 |  | 28.61 |  |  | 20585
 |  | 29.34 |  | 33.24 |  | 33.42 |  | 24.44 |  |  | 17836
 |  | 27.98 |  | 30.65 |  | 30.7 |  | 23.9 |  |  | 17454
 |  | 29.94 |  | 34.03 |  | 34.16 |  | 27.97 |  |  | 19350
 |  | 29.38 |  | 33.87 |  | 34.11 |  | 23.75 |  |  | 19381
 |  | 26.97 |  | 31.43 |  | 31.65 |  | 21.79 |  |  | 19577
 |  | 29.21 |  | 33.35 |  | 33.75 |  | 22.62 |  |  | 20179
 |  | 26.14 |  | 31.11 |  | 32.53 |  | 27.41 |  |  | 20201
 |  | 25.31 |  | 29.79 |  | 30.13 |  | 27.05 |  |  | 18232
 |  | 24.52 |  | 29.21 |  | 29.49 |  | 22.46 |  |  | 18545
 |  | 27.41 |  | 32 |  | 32.99 |  | 29 |  |  | 20175
 |  | 27.48 |  | 32.87 |  | 33.27 |  | 23.82 |  |  | 19790
 |  | 28.15 |  | 33.35 |  | 33.71 |  | 31 |  |  | 19878
 |  | 28.53 |  | 33.85 |  | 34.73 |  | 26.43 |  |  | 19613
 |  | 28.71 |  | 33.76 |  | 35.57 |  | 24.24 |  |  | 19124
 |  | 25.95 |  | 30.2 |  | 30.57 |  | 19.58 |  |  | 17563
 |  | 24.9 |  | 29.47 |  | 29.78 |  | 19 |  |  | 17485
 |  | 28.01 |  | 32.64 |  | 33.57 |  | 22.44 |  |  | 19065
 |  | 27.47 |  | 32.93 |  | 33.81 |  | 24.5 |  |  | 19073
 |  | 29.93 |  | 35.52 |  | 36.75 |  | 31.5 |  |  | 19276
 |  | 32.19 |  | 38.55 |  | 41.23 |  |  |  |  | 19094
 |  | 34.56 |  | 40 |  | 40.67 |  |  |  |  | 18917
 |  | 32.28 |  | 37.37 |  | 37.62 |  |  |  |  | 18338
 |  | 31.33 |  | 36.69 |  | 36.9 |  |  |  |  | 18700
 |  | 34.34 |  | 37.84 |  | 43.58 |  |  |  |  | 19628
 |  | 37.47 |  | 44.03 |  | 44.68 |  |  |  |  | 19310
 |  | 33.32 |  | 40.36 |  | 40.95 |  |  |  |  | 19485
1st Week Avg
2nd Week Avg
3rd Week Avg
4th Week Avg
5th Week Avg
[NAME]
Spreadsheet: 118901d1314091226-total-time-calculation-idle-time
Sheet: Idle

Agent Name | 2011-08-01 00:00:00 | 2011-08-02 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 2011-08-05 00:00:00 | 2011-08-08 00:00:00 | 2011-08-09 00:00:00 | 2011-08-10 00:00:00 | 2011-08-11 00:00:00 | 2011-08-12 00:00:00 | 2011-08-15 00:00:00 | 2011-08-16 00:00:00 | 2011-08-17 00:00:00 | 2011-08-18 00:00:00 | 2011-08-19 00:00:00 | 2011-08-22 00:00:00 | 2011-08-23 00:00:00
Avinash
Dnyaneshwar
Jayesh
Mamta
Manish
Nilesh
Raksha
Supriya
Spreadsheet: 140886d1328923648-large-database-yfeb-food-total-values
Sheet: 2-16-12

 | Breakfast | Quantity | Measure | Food Item | Cost | Daily Points
 | Daily Total
 | Lunch | Quantity | Measure | Food Item | Cost | Daily Points
 | Dinner | Quantity | Measure | Food Items | Cost | Daily Points
Spreadsheet: 831325d1685549729-calculating-sum-using-multiple-criteria-dummy-data-sum-of-sob-and-yrs
Sheet: FY Act vs. Fcst

 |  |  |  | Driver FTE Analysis - Full Year View
 |  |  |  |  | 22/23 | In cell G7, I would like a formula which looks up the year and column C and returns sum for the year
 |  |  |  |  | Staff on Books C/P |  |  | New Starters |  |  |  |  | Trainees to Garage |  |  | Establishment C/P
EST | TG | SOB |  | Depot |  | Static Fcst | Var vs. Static Fcst | Actual | Rolling Fcst | Static Fcst | [NAME] vs. [NAME] | Var vs. Static Fcst |  |  | Var vs. Static Fcst |  | Static Fcst | Var vs. Static Fcst
1.11 | 1.1 | 1 |  | Barking
2.11 | 2.1 | 2 |  | Bow
3.11 | 3.1 | 3 |  | Leyton
4.11 | 4.1 | 4 |  | Romford
5.11 | 5.1 | 5 |  | West Ham
6.11 | 6.1 | 6 |  | Ash Grove
7.11 | 7.1 | 7 |  | Walthamstow Ave
 |  |  |  | Total - East London
8.11 | 8.1 | 8 |  | Rainham
9.11 | 9.1 | 9 |  | Plumstead
10.11 | 10.1 | 10 |  | Catford
11.11 | 11.1 | 11 |  | [NAME]
12.11 | 12.1 | 12 |  | Bromley
 |  |  |  | Total - SELKENT
13.11 | 13.1 | 13 |  | Lea Interchange
14.11 | 14.1 | 14 |  | City Sightseeing
 |  |  |  | Grand Total
 |  |  |  | Graph showing 'so what'
Spreadsheet: 769934d1645726218-replace-word-via-lookup-help224
Sheet: Sheet1

OLD NAME | NEW NAME
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Air Blue_1.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CB_1.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Air Blue_2.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CB_2.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Air Blue_3.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CB_3.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Air Blue_4.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CB_4.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Air Blue_5.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CB_5.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Air Blue_6.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CB_6.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Air Blue_7.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CB_7.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Antique Beige_1.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-AB_1.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Antique Beige_2.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-AB_2.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Antique Beige_3.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-AB_3.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Antique Beige_4.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-AB_4.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Antique Beige_5.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-AB_5.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Antique Beige_6.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-AB_6.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Antique Beige_7.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-AB_7.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Bay Brown_1.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CC_1.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Bay Brown_2.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CC_2.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Bay Brown_3.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CC_3.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Bay Brown_4.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CC_4.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Bay Brown_5.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CC_5.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Bay Brown_6.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CC_6.jpg
C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-Canvas Bay Brown_7.jpg | C:\Users\sunge\Dropbox\! [NAME]! Combined - WF\CUSH270C-CC_7.jpg
Spreadsheet: 44046d1242724520-how-do-i-write-a-positive-negative-and-red-green-function-book11
Sheet: Sheet2

 | Weight1 | Weight2
A | 20 | 15 | 5
B | 20 | 25 | -5
C | 30 | 35 | -5
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 746801d1631034159-sumifs-returning-0-value-sumifs-issues
Sheet: Summary

Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8 | Col 9 | Col 10 | Col 11 | Col 12 | Col 13 | Col 14 | Col 15 | Col 16 | Col 17 | Col 18 | Col 19 | Col 20 | Col 21 | Col 22 | Col 23 | Col 24 | Col 25 | Col 26 | Col 27
Saint Agnes Medical Center | Fresno | CA | Yes | Yes |  | 119 |  |  |  | 146 |  |  |  | 7 |  |  |  | 7 |  |  | 139 |  |  | Saint Agnes Medical Center | 1 | BAMLANIVIMAB
Saint Marys Hospital | Waterbury | CT | Yes | Yes |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  | [NAME], CT | 4 | BARICITINIB
[NAME] and Medical Center | Hartford | CT | Yes | Yes |  | 147 |  |  |  | 398 |  |  |  | 25 |  |  |  | 25 |  |  | 373 |  |  | [NAME] and Medical Center, CT | 3 | CASIRIVIMAB (REGN10933)
Johnson Memorial Hospital | [NAME] | CT | Yes | Yes |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  | Johnson Memorial Hospital, CT | 67 | CASIRIVIMAB/IMDEVIMAB
Mount Sinai Rehabilitation Hospital | Hartford | CT | Yes | Yes |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0 |  |  | Mount Sinai Rehabilitation Hospital | 68 | ETESEVIMAB
[NAME] | [NAME] | DE | Yes | Yes |  | 39 |  |  |  | 57 |  |  |  | 10 |  |  |  | 10 |  |  | 47 |  |  | St. Francis Hospital Wilmington DE | 69 | IMDEVIMAB (REGN10987)
Holy Cross Hospital | Fort Lauderdale | FL | Yes | Yes |  | 0 |  |  |  | 34 |  |  |  | 34 |  |  |  | 34 |  |  | 0 |  |  | Holy Cross Hospital, FL | 5
St Marys Hospital | Athens | GA | Yes | Yes |  | 153 |  |  |  | 103 |  |  |  | 102 |  |  |  | 102 |  |  | 1 |  |  | St. Mary's Hospital, GA | 6
St Marys Sacred Heart Hospital (FKA Ty Cobb Regional Medical Center) | Lavonia | GA | Yes | Yes |  | 129 |  |  |  | 75 |  |  |  | 78 |  |  |  | 75 |  |  | 0 |  |  | St. Mary's Sacred Heart Hospital, GA | 8
St Marys Good Samaritan Hospital | Greensboro | GA | Yes | Yes |  | 36 |  |  |  | 41 |  |  |  | 14 |  |  |  | 14 |  |  | 27 |  |  | St. Mary's Good Samaritan Hospital, GA | 7