tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 788854d1658765835-separating-text-and-numbers-eg-bible-book-chapter-verse-bible-verse
Sheet: Books of the Bible

Name of the Book | Number of Chapters
Genesis | 50
Exodus | 40
Leviticus | 27
Numbers | 36
Deuteronomy | 34
[NAME] | 24
Judges | 21
[NAME] | 4
1 Samuel | 31
2 Samuel | 24
1 Kings | 22
2 Kings | 25
1 Chronicles | 29
2 Chronicles | 36
[NAME] | 10
Nehemiah | 13
Esther | 10
Job | 42
Psalms | 150
Proverbs | 31
Ecclesiastes | 12
Song of [NAME] | 8
[NAME] | 66
Jeremiah | 52
Lamentations | 5
Ezekiel | 48
[NAME] | 12
Hosea | 14
Joel | 3
[NAME] | 9
Obadiah | 1
Jonah | 4
Micah | 7
Nahum | 3
Habakkuk | 3
Zephaniah | 3
Haggai | 2
Zechariah | 14
Malachi | 4
[NAME] | 28
Mark | 16
[NAME] | 24
[NAME] | 21
Acts | 28
Romans | 16
1 Corinthians | 16
2 Corinthians | 13
Galatians | 6
Ephesians | 6
Philippians | 4
Colossians | 4
1 Thessalonians | 5
2 Thessalonians | 3
1 Timothy | 6
2 Timothy | 4
Titus | 3
Philemon | 1
Hebrews | 13
[NAME] | 5
1 [NAME] | 5
2 [NAME] | 3
1 [NAME] | 5
2 [NAME] | 1
3 [NAME] | 1
[NAME] | 1
Revelation | 22
Spreadsheet: 96049d1295526744-formula-for-interval-prices-formula-interval
Sheet: Blad1

Length | [NAME] | Amount | Worktime h /pcs | Total Worktime (rules as below)
1000 | 500 | 10 | 10 | 165 ((Pcs 1-3 (3 pcs *10*2)+ Pcs 4-10 (7 pcs * 10 *1.5))
1000 | 600 | 1 | 10 | 20 ((Pcs 1-3 (1 pcs * 10*2))
1000 | 700 | 50 | 10 | 565 ((Pcs 1-3 (3 pcs *10*2)+ Pcs 4-10 (7 pcs * 10 *1.5) + Pcs 11-50 (40pcs *10*1))
Rules
Pcs 1-3, worktime 10 x 2 per piece |  |  |  | How do I make a formula for such rules?
Pcs 4-10, worktime 10 x 1.5 per piece
Pcs >10, worktime 10 x 1 per piece (standard rate)
Spreadsheet: 25559d1216919244-is-sumif-the-appropriate-formula-for-what-i-am-trying-to-do-copy-of-attachment
Sheet: Sheet1

Project | Total | Funding that is here | Funding that is not here | R&D Funding that is here | R&D Funding that is not here | Quarter
A |  | 0 | 0 | 0 | 1346 | 3
B |  | 654 | 0 | 0 | 0 | 1
C |  | 0 | 145 | 0 | 65 | 4
D |  | 0 | 65 | 0 | 13 | 2
E |  | 0 | 576 | 0 | 687468 | 3
F |  | 46214 | 0 | 0 | 0 | 1
G |  | 0 | 0 | 234 | 0 | 4
H |  | 0 | 847 | 0 | 654 | 2
I |  | 0 | 525 | 0 | 3684 | 4
J |  | 682 | 0 | 0 | 0 | 1
K |  | 0 | 24 | 0 | 368 | 3
L |  | 0 | 57246 | 0 | 41 | 4
M |  | 578 | 0 | 4 | 0 | 1
N |  | 0 | 683 | 0 | 486 | 2
O |  | 0 | 56 | 0 | 436 | 3
P |  | 0 | 78356 | 0 | 0.4 | 4
Q |  | 3568 | 0 | 13 | 0 | 1
R |  | 0 | 457 | 0 | 64 | 2
 |  | 0 | 0 | 0 | 0 | 2
S |  | 0 | 2457 | 0 | 3684 | 2
T |  | 0 | 8356 | 0 | 65 | 4
Q1 | 51713
Q2 | 9410
Q3 | 690274
Q4 | 148717.4
Spreadsheet: 733630d1621673076-get-remarks-value-base-on-the-code-no-and-unique-no-for-asking-2021-0522-ans
Sheet: Sheet2

 | Expected Result |  |  |  | [NAME]
 | CODE NO. | MARKS |  |  | CODE NO. | MARKS
1 | 111-221 | o
1 | 111-222 | o
1 | 111-223
1 | 111-224
1 | 111-225 | o
2 | 111-225 | x
3 | 111-225 | x
1 | 111-226 | o
2 | 111-226 | o
1 | 111-227 | o
2 | 111-227 | o
3 | 111-227 | x
4 | 111-227 | x
5 | 111-227 | x
6 | 111-227 | o
1 | 111-228 | x
2 | 111-228 | x
3 | 111-228 | o
Spreadsheet: 809436d1671092126-combining-if-and-vlookup-functions-scoring-sheet
Sheet: Scoring Sheet

BMI | [NAME] (n) | Push Ups Score  (%)
18 | 30
21 | 12
35 | 20
32 | 6
26 | 13
18 | 10
39 | 9
25 | 2
31 | 0
Spreadsheet: 1d0dc7d2-e083-49cd-b947-88421c4f639b
Sheet: Sheet1

#19386 Sumitomo Gear Box 2-26-04 | Unnamed: 1 | Unnamed: 2
rev 2/27/04 ecb
 | Motion Industries | Falcon Pump
Responded by | [NAME] | [NAME]
Item | Sumitomo [NAME] | Sumitomo [NAME]
Model # | CVVJS-6195Y-35 | CVVJS-6195Y35-286TC
Price | 10735 | 13060
Lead time | 12 weeks | 3-4 weeks
FOB Point | [NAME], CO | [NAME], CO
Meets specs? | Yes | Yes
Comments
Spreadsheet: 889244d1739979027-simple-lookup-giving-me-problems-today-sample-mmh
Sheet: 2025

 |  | Detailed Trial Balance | Detailed Income Statement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Profit
 |  | Month 1 |  | 2025
 |  |  |  |  |  |  | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00 | YTD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YTD
 |  |  |  |  | REVENUE: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REVENUE:
 |  |  |  |  | New |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | New
 |  |  |  |  | Used |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Used
 |  |  |  |  | Service |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Service
 |  |  |  |  | Parts |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parts
 |  |  |  |  | Rental |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rental
 |  |  |  |  | Allied |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Allied
 |  |  |  |  | Labor Sublet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Sublet
 |  |  |  |  | Other Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Revenue
 |  |  |  |  | Total Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Revenue
Spreadsheet: 329924d1404458987-sales-projection-dc-final
Sheet: srilanka

 | Europe | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | Total | share | Growth% | CAGR | CAGR
 | GERMANY | 3133 | 2062 | 1661 | 1877 | 2582 | 1829
 | SPAIN | 1990 | 1368 | 1511 | 1331 | 2574 | 1853
 | FRANCE | 2371 | 1449 | 1812 | 1187 | 1773 | 1524
 | PORTUGAL | 1583 | 1148 | 1398 | 793 | 1468 | 1006
 | UK | 1111 | 845 | 651 | 907 | 998 | 1510
 | NETHERLAND | 1239 | 640 | 312 | 473 | 620 | 487
 | GREECE | 648 | 588 | 490 | 442 | 445 | 519
 | ITALY | 435 | 313 | 323 | 386 | 548 | 501
 | BELGIUM | 191 | 338 | 274 | 382 | 462 | 389
 | POLAND | 274 | 349 | 202 | 261 | 362 | 159
 | CROATIA | 100 | 175 | 75 | 103 | 138 | 98
 | BULGARIA | 62 | 25 | 100 | 99 | 97 | 152
 | AUSTRIA | 50 | 0 | 25 | 12 | 107 | 32
 | RUSSIA | 0 | 0 | 0 | 34 | 183 | 0
 | CZECHOSLOVAKIA | 9 | 86 | 0 | 0 | 103 | 0
 | CYPRUS | 42 | 49 | 38 | 3 | 32 | 2
 | MALTA | 43 | 41 | 8 | 31 | 0 | 37
 | HUNGRY | 0 | 24 | 48 | 0 | 75 | 0
 | SLOVENIA | 0 | 0 | 0 | 12 | 37 | 12
 | CZECH REPUBLIC | 0 | 0 | 0 | 0 | 0 | 58
 | DENMARK | 0 | 9 | 8 | 9 | 0 | 22
 | BOSNIA | 0 | 0 | 0 | 13 | 13 | 0
 | SWEDEN | 0 | 0 | 0 | 0 | 25 | 0
 | IRELAND | 0 | 0 | 0 | 0 | 0 | 21
 | Asia & Pacific | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | Total | Share | Growth % | CAGR | CAGR
1 | AUSTRALIA | 180 | 150 | 133 | 99 | 446 | 224
2 | BAHARAIN IS | 252 | 107 | 90 | 59 | 0 | 80
3 | IRAN | 996 | 724 | 1965 | 1337 | 2728 | 2234
4 | JAPAN | 48 | 38 | 35 | 12 | 14 | 21
5 | JORDAN | 348 | 680 | 1411 | 572 | 1338 | 2687
6 | KUWAIT | 67 | 184 | 272 | 46 | 215 | 550
7 | LEBANON | 270 | 224 | 305 | 193 | 0 | 325
8 | NEWZEALAND | 0 | 0 | 0 |  | 0 | 32
9 | OMAN | 0 | 139 | 396 | 482 | 485 | 409
10 | PAKISTAN IR | 4014 | 1765 | 2369 | 1644 | 1915 | 2946
11 | QATAR | 64 | 100 | 75 | 33 | 75 | 38
12 | SAUDI ARAB | 2871 | 2647 | 3965 | 2475 | 3389 | 3588
13 | SINGAPORE | 4 | 20 | 67 | 0 | 0 | 0
14 | SYRIA | 603 | 926 | 682 | 26 | 901 | 248
15 | TURKEY | 1417 | 1424 | 654 | 492 | 1141 | 744
16 | U ARAB EMTS | 10582 | 9558 | 9013 | 5985 | 8529 | 4545
 | America | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | Total | Share | CAGR | CAGR
 | U S A | 1012 | 947 | 1114 | 2023 | 2812 | 2884
 | BRAZIL | 211 | 298 | 172 | 75 | 59 | 593
 | ARGENTINA | 268 | 317 | 93 | 80 | 204 | 136
 | CHILE | 164 | 121 | 112 | 138 | 165 | 111
 | CANADA | 53 | 99 | 52 | 10 | 64 | 355
 | URUGUAY | 25 | 0 | 0 | 0 | 0 | 88
 | Total
 | Africa | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | Total | CAGR |  | Share
 | SOUTH AFRICA | 628 | 358 | 200 | 118 | 387 | 0
 | EGYPT A RP | 5194 | 3845 | 4790 | 3125 | 4831 | 4594
 | MAURITIUS | 5 | 18 | 7 | 5 | 41 | 61
 | MORROCO | 78 | 231 | 200 | 0 | 0 | 126
 | MOZAMBIQUE | 0 | 0 | 37 | 23 | 12 | 35
 | SUDAN | 0 | 0 | 428 | 438 | 449 | 637
 | ZAMBIA | 0 | 0 | 200 | 118 | 387 | 241
Spreadsheet: 157649d1337816517-simplify-copy-column-removing-non-zero-values-formula-approach-copylist
Sheet: Sheet1

Name | Value | Row | [NAME]
Name1 | 0
[NAME] | 10
Name3 | 12
Name4
Name5 | 1
Name6 | -10
Name7 | 12
Name8 | 0
Name9 | 0
Name10 | 1
^- List includes blank cells at end
Spreadsheet: tracy_geaccone__40591__CF_GPG_CONS
Sheet: SEPTCM 

Enron Gas Pipeline Group
Statement of Consolidated Cash Flows
For the 1 month ended September 30, 2000
 | CONSOLIDATED |  |  |  |  |  |  | HPLO | HPL | LRC | SERVICE | GPG CASH |  |  | TOTAL
(In Thousands) | GPG & EOTT |  | GPG | NNG | TW | EC | NP | 543 | 584 | 583 | COS | SERVICES | OTHER |  | EOTT
Operating Cash Inflows (Outflows)
Net income before financing costs
Financing costs
NI after financing costs (excluding cons subs equity earn)
Depreciation, depletion and amortization
Deferred income taxes
Gains on sales of assets and investments
Dividends on pref securities of subsidiary cos.
Equity earnings
Equity/partnership distributions
Other, net
Funds Flow
Changes in components of working capital
Receivables
A/R, A/P - Intercompany
Inventories
Prepayments
Payables
Exchange Rec/Payable
Accrued taxes
Accrued interest
Other working capital
Total changes in components of working capital
Net Cash Provided by Operating Activities
Investing Cash Inflows (Outflows)
Proceeds from sale of assets and investments
Capital Expenditures
Underground Storage,Salvage & Removal Costs
EOTT Revolver and API's
Other investing activities - intercompany
Other investing activities, net
Net Cash Provided by Investing Activities
Cash Flows From Financing Activities
Net increase (decrease) in short-term borrowings
Issuance of long-term debt
Repayment of long-term debt
Other financing activities - I/C
Other financing activities, net
Net Cash Provided by Financing Activities
INC (DEC) IN CASH & CASH EQUIV, I/C CASH FROM CORP
INC (DEC) IN CASH & CASH EQUIV
INC (DEC) INTERCOMPANY CASH FROM CORPORATE
Change in other obligations
Change in total obligations
Spreadsheet: 1f7df3c1-ca37-4456-b394-b5b43ffa6166
Sheet: total spending all materials

Total Library Materials Expenditures FY09 and FY10
Library budget only
Material type | FY09 | FY10 | % change | % of total FY10 expend.
Monographs
Kingston | 293919.46 | 343565.02
[NAME] (pelf) | 2168.62 | 76.5
CCE (ccef) | 7058.43 | 13780.93
Serials / subscriptions
Kingston | 2602491.17 | 2726388.62
[NAME] (pelp) | 27264.41 | 10536.48
CCE (ccep) | 4194.3 | 4460.97
TOTALS
Endowments
Fund code | FY09 | FY10 | % change
Monographs
Kingston | 21098.01 | 3810.68
[NAME] | 0 | 0 | 0
CCE | 0 | 0 | 0
Serials / subscriptions
Kingston | 36466.84 | 36582.03
[NAME] | 0 | 0 | 0
CCE | 0 | 0 | 0
Totals
University Libraries | FY09 | FY10 | % change | % of total FY10 expend.
All branches
Endowments |  | 40392.71
TOTALS
Spreadsheet: 729819d1619369422-index-and-filter-functions-workaround-to-sort-filter-and-format-within-array-example
Sheet: Slide 7 LT

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drag formula down to fil in boxes if necessary.  [NAME] will change when potential column is filled
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paste Option: Paste as Picture
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manually fill in # indirect/direct reports
 | Name | Ttile | Level | Gender/POC | Time in WRK | Time in Level | Risk of Loss | Impact of Loss | Developmental Areas | Core Strengths | Potential Next Role | Move time |  |  | # of Direct Reports | # of Indirect Reports | Blocks should auto-populate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 5
Spreadsheet: 174361aa-26a7-49d3-a625-0074f4a9d8a3
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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Total Class Hours | Unnamed: 36
UTopia | Last Name, First Name | Phone Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Student hours | % Attended
Spreadsheet: 759761d1639708883-lookup-formula-using-multiple-criteria-including-ranges-in-two-columns-test1
Sheet: rate

ID Number | Start Date | End Date | Pay Rate 1
195 | 2017-05-08 00:00:00 | 2017-07-02 00:00:00 | 24.3
195 | 2017-07-03 00:00:00 | 2017-07-23 00:00:00 | 25.311
195 | 2017-07-24 00:00:00 | 2018-07-01 00:00:00 | 25.311
195 | 2018-07-02 00:00:00 | 2018-10-24 00:00:00 | 25.9839
195 | 2018-10-25 00:00:00 | 2019-06-30 00:00:00 | 25.9839
195 | 2019-07-01 00:00:00 | 2019-10-06 00:00:00 | 26.7635
195 | 2019-10-07 00:00:00 | 2020-03-01 00:00:00 | 26.7635
195 | 2020-03-02 00:00:00 | 2020-09-30 00:00:00 | 26.7635
195 | 2020-10-01 00:00:00 | 2021-01-31 00:00:00 | 26.7635
195 | 2021-02-01 00:00:00 | 2021-02-28 00:00:00 | 27.2303
195 | 2021-03-01 00:00:00 | 2021-08-31 00:00:00 | 27.2303
195 | 2021-09-01 00:00:00 | 9999-12-31 00:00:00 | 27.9111
282 | 2017-06-07 00:00:00 | 2017-07-02 00:00:00 | 24.3
282 | 2017-07-03 00:00:00 | 2017-07-23 00:00:00 | 25.311
282 | 2017-07-24 00:00:00 | 2018-07-01 00:00:00 | 25.31
282 | 2018-07-02 00:00:00 | 2018-10-24 00:00:00 | 25.9839
282 | 2018-10-25 00:00:00 | 2019-06-30 00:00:00 | 25.9839
282 | 2019-07-01 00:00:00 | 2019-10-06 00:00:00 | 26.7635
282 | 2019-10-07 00:00:00 | 2019-11-10 00:00:00 | 26.7635
282 | 2019-11-11 00:00:00 | 2020-07-05 00:00:00 | 21.4108
282 | 2020-07-06 00:00:00 | 2020-11-02 00:00:00 | 21.4108
Spreadsheet: 158637d1338324269-looking-to-reference-specific-cells-under-multiple-conditions-cross-ref
Sheet: Cross Reference

Unit | Count | Series | Existing | Replacement
A | 1.5 | 200 | 1KG2099 | CD678-0Y15-200
A | 2 | 200 | 2KG2099 | CD678-0002-200
A | 3 | 200 | 3KG2099 | CD678-0003-200 | * This is the "Master" sheet, cross referencing every product
A | 5 | 300 | 5KG2099 | CD678-0005-300
A | 7.5 | 300 | 7KG2099 | CD678-0Y75-300
A | 10 | 300 | 10KG2099 | CD678-0010-300
A | 15 | 400 | 15KG2099 | CD678-0015-400
A | 20 | 400 | 20KG2099 | CD678-0020-400
A | 25 | 400 | 25KG2099 | CD678-0025-400
A | 30 | 400 | 30KG2099 | CD678-0030-400
B | 40 | 500 | 40KG2099 | CD678-0040-500
B | 50 | 500 | 50KG2099 | CD678-0050-500
B | 60 | 500 | 60KG2099 | CD678-0060-500
B | 75 | 500 | 75KG2099 | CD678-0075-500
C | 100 | 600 | 100KG2099 | CD678-0100-600
C | 125 | 600 | 125KG2099 | CD678-0125-600
C | 150 | 600 | 150KG2099 | CD678-0150-600
Spreadsheet: 668433d1584819661-extract-rows-data-with-3-conditions-q2-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Done |  |  | Desired results
 |  | X | X |  | X |  | X |  | Option 1 |  |  | Option 2
 | Name | A1 | B1 | C1 | D1 | E1 | F1 |  |  |  |  | A1 | AAAAA
 | AAAAA | X |  | X | X |  | X |  |  |  |  |  | EEED
 | DSAS |  | X |  | X | X |  |  |  |  |  |  | CCFF
 | EEED | X | X |  |  |  | X |  |  |  |  |  | ABMLIG
 | CCFF | X | X |  | X | X |  |  |  |  |  |  | QASD
 | AZAS |  |  | X | X |  |  |  |  |  |  |  | FGHK
 | ABMLIG | X |  | X |  |  | X |  |  |  |  |  | zzzzz
 | QASD | X | X | X |  |  |  |  |  |  |  | B1 | DSAS
 | FGHK | X | X |  | X | X |  |  |  |  |  |  | EEED
 | zzzzz | X |  | X | X |  |  |  |  |  |  |  | CCFF
 | WRTYU |  | X |  |  |  | X |  |  |  |  |  | QASD
 |  |  |  |  |  |  |  |  |  |  |  |  | FGHK
 | In option 1 - are extracted from B4:B13 marked "X" for ALL C3:H3 |  |  |  |  |  |  |  |  |  |  |  | WRTYU
 | In option 2 - I would like to extract the same B4:B13 marked "X" but ONLY for C3:H3 marked "X" in C2:H2 |  |  |  |  |  |  |  |  |  |  | D1 | AAAAA
 |  |  |  |  |  |  |  |  |  |  |  |  | DSAS
 |  |  |  |  |  |  |  |  |  |  |  |  | CCFF
 |  |  |  |  |  |  |  |  |  |  |  |  | AZAS
 |  |  |  |  |  |  |  |  |  |  |  |  | FGHK
 |  |  |  |  |  |  |  |  |  |  |  |  | zzzzz
 |  |  |  |  |  |  |  |  |  |  |  | F1 | AAAAA
 |  |  |  |  |  |  |  |  |  |  |  |  | EEED
 |  |  |  |  |  |  |  |  |  |  |  |  | ABMLIG
 |  |  |  |  |  |  |  |  |  |  |  |  | WRTYU
Spreadsheet: 32340d1228444355-workbook-stripped-of-format-after-its-saved-mastertemplate_standard-calc-november-2008v4_corrupt-corrected
Sheet: Contract Billing Addt'l Courses

Contract Billing Authorization Form Attachment for Additional Courses
Course | CRN | Course No. & Section |  |  | Course Dates |  |  | # of Students |  | Course | CRN | Course No. & Section |  | Course Dates |  |  | # of Students
11 |  |  |  |  |  |  |  |  |  | 36
12 |  |  |  |  |  |  |  |  |  | 37
13 |  |  |  |  |  |  |  |  |  | 38
14 |  |  |  |  |  |  |  |  |  | 39
15 |  |  |  |  |  |  |  |  |  | 40
16 |  |  |  |  |  |  |  |  |  | 41
17 |  |  |  |  |  |  |  |  |  | 42
18 |  |  |  |  |  |  |  |  |  | 43
19 |  |  |  |  |  |  |  |  |  | 44
20 |  |  |  |  |  |  |  |  |  | 45
21 |  |  |  |  |  |  |  |  |  | 46
22 |  |  |  |  |  |  |  |  |  | 47
23 |  |  |  |  |  |  |  |  |  | 48
24 |  |  |  |  |  |  |  |  |  | 49
25 |  |  |  |  |  |  |  |  |  | 50
26 |  |  |  |  |  |  |  |  |  | 51
27 |  |  |  |  |  |  |  |  |  | 52
28 |  |  |  |  |  |  |  |  |  | 53
29 |  |  |  |  |  |  |  |  |  | 54
30 |  |  |  |  |  |  |  |  |  | 55
31 |  |  |  |  |  |  |  |  |  | 56
32 |  |  |  |  |  |  |  |  |  | 57
33 |  |  |  |  |  |  |  |  |  | 58
34 |  |  |  |  |  |  |  |  |  | 59
35 |  |  |  |  |  |  |  |  |  | 60
Spreadsheet: 495308b3-244d-4419-bc42-cbfda2b2e3bc
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
ANA2 | Test | ANA2 | Antinuclear Antibodies (ANA), Serum | Antinuclear Ab, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | < or =1.0 U (negative) 1.1-2.9 U (weakly positive) 3.0-5.9 U (positive) > or =6.0 U (strongly positive) Reference values apply to all ages. | Monday through Friday, Saturday; 11 a.m. | 1 day | 1 day | 1 | 86038 |  |  |  |  | Rochester
ANA2 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
ANA2 | Result | ANA2 | Antinuclear Ab, S | Antinuclear Ab, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 5047-6
Spreadsheet: 192553d1352456413-display-multiple-search-results-by-column-example1-1
Sheet: Sheet1

Station | TOC 1 | TOC 2 | TOC 3 | TOC 4 | TOC 5 | TOC 6 | TOC 7 | Station | TOC
Abergavenny | Arriva Trains Wales | East Coast | First Capital Connect |  |  |  |  | Abergavenny | Arriva Trains Wales
Abergele & Pensarn | Arriva Trains Wales |  |  |  |  |  |  | Abergele & Pensarn | Arriva Trains Wales
Aberystwyth | Arriva Trains Wales |  |  |  |  |  |  | Aberystwyth | Arriva Trains Wales
[NAME] | East Coast |  |  |  |  |  |  | [NAME] | Arriva Trains Wales
Inverness | East Coast | First Capital Connect |  |  |  |  |  | Abergavenny | East Coast
[NAME] | East Coast |  |  |  |  |  |  | Inverness | East Coast
Kingussie | First Capital Connect |  |  |  |  |  |  | [NAME] | East Coast
[NAME] | First Capital Connect |  |  |  |  |  |  | Kingussie | East Coast
[NAME] |  |  |  |  |  |  |  | Abergavenny | First Capital Connect
 |  |  |  |  |  |  |  | [NAME] | First Capital Connect
 |  |  |  |  |  |  |  | Inverness | First Capital Connect
 |  |  |  |  |  |  |  | [NAME] | First Capital Connect
Spreadsheet: 5f9184ab-d679-4168-9014-0dcf69f43267
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42470127 | 2014-07-27 05:14:43 | ALLIES | 1 | 6 | 3 | 622736 | [NAME] | 15105 | western | 1944-07-11 |  |  | (CB#1)  COTE 112
42526761 | 2014-07-31 04:37:46 | AXIS | 0 | 3 | 6 | 622736 | [NAME] | 14892 | western | 1944-08-06 |  | [Final Four][Normandy] Ambrières' bridge | [Final Four][Normandie] Le pont d'Ambrières
Spreadsheet: 714047d1611069782-sum-with-multiple-criteria-sumifs-query-v2
Sheet: Sheet1

 |  | TABLE A
 |  |  |  |  |  |  |  | 2020/21 | 2020/21 | 2020/21
 |  | CostCtre | DeptCode | Job Number | Project Number i.e. this is the NOC, NPFC or AT number | Project Header | Activity | Period Number | Period Number | Period Number
 |  |  |  |  |  |  |  | 10 | 11 | 12
 |  | ABC | DEP | 123 |  | Labour_Solutions | Start Up | 1644.522530953505 | 1644.522530953505 | 1644.522530953505
 |  | DEF | DEP | 123 |  | Labour_Solutions | Feasibility | 27359.39386884803 | 27359.39386884803 | 27359.39386884803
 |  | GHI | DEP | 123 |  | Labour_Solutions | Closure | 48410.2402067556 | 48410.2402067556 | 48410.2402067556
 |  | JKL | DEP | 123 |  | Labour_Solutions | Invoicing | 3979.475667812074 | 3979.475667812074 | 3979.475667812074
 |  | MNO | DEP | 123 |  | Labour_Quality | Implementation | 16018.07660019648 | 16018.07660019648 | 16018.07660019648
 |  | PQR | DEP | 123 |  | Labour_Quality | Documentation | 8009.038300098238 | 8009.038300098238 | 8009.038300098238
 |  | TABLE B
 |  | Project | Project Header | Phase | Stage | Activity | Period Number | Period Number | Period Budget
 |  | 123 | Labour_Solutions |  |  | Start Up | 10 | 2020
 |  | 123 | Labour_Solutions |  |  | Feasibility | 10 | 2020
 |  | 123 | Labour_Solutions |  |  | Closure | 10 | 2020
 |  | 123 | Labour_Solutions |  |  | Invoicing | 10 | 2020
 |  | 123 | Labour_Quality |  |  | Implementation | 10 | 2020
 |  | 123 | Labour_Quality |  |  | Documentation | 10 | 2020
 |  | 123 | Labour_Solutions |  |  | Start Up | 11 | 2020
 |  | 123 | Labour_Solutions |  |  | Feasibility | 11 | 2020
 |  | 123 | Labour_Solutions |  |  | Closure | 11 | 2020
 |  | 123 | Labour_Solutions |  |  | Invoicing | 11 | 2020
 |  | 123 | Labour_Quality |  |  | Implementation | 11 | 2020
 |  | 123 | Labour_Quality |  |  | Documentation | 11 | 2020
 |  | 123 | Labour_Solutions |  |  | Start Up | 12 | 2020
 |  | 123 | Labour_Solutions |  |  | Feasibility | 12 | 2020
 |  | 123 | Labour_Solutions |  |  | Closure | 12 | 2020
 |  | 123 | Labour_Solutions |  |  | Invoicing | 12 | 2020
 |  | 123 | Labour_Quality |  |  | Implementation | 12 | 2020
 |  | 123 | Labour_Quality |  |  | Documentation | 12 | 2020
 |  |  |  |  | Hi, How do I get the values in col H, I & J from table A into the table below by Project header and Period Number please?  I think it is some form of sumifs statement, but nothing I do is working.  Hoping someone can advise please.  Thank you so much in advance!  [NAME]
Spreadsheet: 116151d1311628419-excel-2007-sum-if-across-range-possibly-using-index-match-sumproduct-or-hlookup-sample
Sheet: Source data

 |  | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00
Yes | Line 1 |  | 10000 | 15000
Yes | Line 2 |  |  | 80000
Yes | Line 3 | 20000
No | Line 4 |  | 10000
No | Line 5 |  | 3000
Yes | Line 6 |  | 45000
 | Week | 2011-09-09 00:00:00 | 2011-09-16 00:00:00 | 2011-09-23 00:00:00 | 2011-09-30 00:00:00 | 2011-10-07 00:00:00 | 2011-10-14 00:00:00 | 2011-10-21 00:00:00 | 2011-10-28 00:00:00 | 2011-11-04 00:00:00 | 2011-11-11 00:00:00 | 2011-11-18 00:00:00 | 2011-11-25 00:00:00 | 2011-12-02 00:00:00 | 2011-12-09 00:00:00 | 2011-12-16 00:00:00 | 2011-12-23 00:00:00 | 2011-12-30 00:00:00
 | Month | 2011-09-30 00:00:00 | 2011-09-30 00:00:00 | 2011-09-30 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-10-31 00:00:00 | 2011-10-31 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-11-30 00:00:00 | 2011-11-30 00:00:00 | 2011-11-30 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00 | 2011-12-31 00:00:00
 | End of Month? |  |  |  | Yes |  |  |  | Yes |  |  |  |  | Yes |  |  |  | Yes
 | End of Month - date
 | Sum of lines 1 -6
 | Answer: