tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 214975d1361214731-summing-time-series-data-192-summing-time-series-data
Sheet: Sheet1

Date and Time | Logger reading
2012-02-01 09:00:00 | 10
2012-02-01 09:02:00 | 11
2012-02-01 09:04:00 | 4
2012-02-01 09:05:59.985000 | 3
2012-02-01 09:07:59.980000 | 6
2012-02-01 09:09:59.975000 | 8
2012-02-01 09:11:59.970000 | 2
2012-02-01 09:13:59.965000 | 1
2012-02-01 09:15:59.960000 | 6
2012-02-01 09:17:59.955000 | 6
2012-02-01 09:19:59.950000 | 3
2012-02-01 09:21:59.945000 | 14
2012-02-01 09:23:59.940000 | 0
2012-02-01 09:25:59.935000 | 4
2012-02-01 09:27:59.930000 | 2
2012-02-01 09:29:59.925000 | 2
2012-02-01 09:31:59.920000 | 2
2012-02-01 09:33:59.915000 | 2
2012-02-01 09:35:59.910000 | 1
2012-02-01 09:37:59.905000 | 5
2012-02-01 09:39:59.900000 | 2
2012-02-01 09:41:59.895000 | 11
2012-02-01 09:43:59.890000 | 1
2012-02-01 09:45:59.885000 | 5
2012-02-01 09:47:59.880000 | 5
2012-02-01 09:49:59.875000 | 5
2012-02-01 09:51:59.870000 | 6
2012-02-01 09:53:59.865000 | 5
2012-02-01 09:55:59.860000 | 3
2012-02-01 09:57:59.855000 | 6
2012-02-01 09:59:59.850000 | 3
2012-02-01 10:01:59.845000 | 12
2012-02-01 10:03:59.840000 | 2
2012-02-01 10:05:59.835000 | 1
2012-02-01 10:07:59.830000 | 3
2012-02-01 10:09:59.825000 | 7
2012-02-01 10:11:59.820000 | 7
2012-02-01 10:13:59.815000 | 15
2012-02-01 10:15:59.810000 | 6
2012-02-01 10:17:59.805000 | 5
2012-02-01 10:19:59.800000 | 10
2012-02-01 10:21:59.795000 | 10
2012-02-01 10:23:59.790000 | 8
2012-02-01 10:25:59.785000 | 14
2012-02-01 10:27:59.780000 | 9
2012-02-01 10:29:59.775000 | 6
2012-02-01 10:31:59.770000 | 6
2012-02-01 10:33:59.765000 | 2
2012-02-01 10:35:59.760000 | 28
2012-02-01 10:37:59.755000 | 13
2012-02-01 10:39:59.750000 | 6
2012-02-01 10:41:59.745000 | 5
2012-02-01 10:43:59.740000 | 1
2012-02-01 10:45:59.735000 | 2
2012-02-01 10:47:59.730000 | 9
2012-02-01 10:49:59.725000 | 10
2012-02-01 10:51:59.720000 | 14
2012-02-01 10:53:59.715000 | 9
2012-02-01 10:55:59.710000 | 4
2012-02-01 10:57:59.705000 | 6
2012-02-01 10:59:59.700000 | 0
2012-02-01 11:01:59.695000 | 6
2012-02-01 11:03:59.690000 | 6
2012-02-01 11:05:59.685000 | 3
2012-02-01 11:07:59.680000 | 6
2012-02-01 11:09:59.675000 | 7
2012-02-01 11:11:59.670000 | 9
2012-02-01 11:13:59.665000 | 4
2012-02-01 11:15:59.660000 | 10
2012-02-01 11:17:59.655000 | 10
2012-02-01 11:19:59.650000 | 7
2012-02-01 11:21:59.645000 | 9
2012-02-01 11:23:59.640000 | 2
2012-02-01 11:25:59.635000 | 3
2012-02-01 11:27:59.630000 | 9
2012-02-01 11:29:59.625000 | 4
2012-02-01 11:31:59.620000 | 7
2012-02-01 11:33:59.615000 | 16
2012-02-01 11:35:59.610000 | 6
2012-02-01 11:37:59.605000 | 7
2012-02-01 11:39:59.600000 | 10
2012-02-01 11:41:59.595000 | 13
2012-02-01 11:43:59.590000 | 7
2012-02-01 11:45:59.585000 | 8
2012-02-01 11:47:59.580000 | 9
2012-02-01 11:49:59.575000 | 8
2012-02-01 11:51:59.570000 | 5
2012-02-01 11:53:59.565000 | 10
2012-02-01 11:55:59.560000 | 9
2012-02-01 11:57:59.555000 | 7
2012-02-01 11:59:59.550000 | 4
Spreadsheet: 598873d1542756395-extract-sales-data-into-age-brackets-by-sales-rep-age-bracket-sample
Sheet: Sheet1

Invoice Date | Client Number | First Name | Last Name | Lead Source | Invoice Total | Payment Total | Open Balance | Photographer Name | Producer | Assistant | Booker | Make-Up Artist | [NAME] | Invoice Status | Invoice Classification | Session Type | Age | State | Units | Units2 | Units3 | <1000 | <1 | Open | Month | Week | Day | Duplicate | 10% or 150 | Selected? |  | 13 to 17 | 18 to 24 | 25 to 33 | 34 to 40 | 41 to 50 | 51 +
2018-11-19 00:00:00 | 20078824HAQ | Mansura | Haque | PMC_S_18 | 300 | 300 | 0 |  | [NAME] |  | [NAME] |  | Photographed | Paid (Fee) | Session Deposit  Fee |  | 18
2018-11-19 00:00:00 | 30081265KEA | Melina | Keast | In Bound Phone Call | 325 | 325 | 0 |  | Mirella |  | Mirella |  | Booked | Paid (Fee) | Booking Fee |  | 16
2018-11-19 00:00:00 | 20077911SET | [NAME] | [NAME] | PMC_S_18 | 59 | 59 | 0 |  | Lyka |  | Lyka |  | Booked | Paid (Fee) | E-Way |  | 28
2018-11-19 00:00:00 | 30081233 | [NAME] | Sao | Category Quick Enquiry | 79 | 79 | 0 |  | Natasha |  | Natasha |  | Booked | Paid (Fee) | Booking Fee |  | 36
2018-11-19 00:00:00 | 20078263LIN | Cathy | [NAME] | PMC_S_18 | 79 | 79 | 0 |  | Julie |  | Julie |  | Booked | Unpaid (Fee) | Booking Fee |  | 45
2018-11-19 00:00:00 | 20081562 | Dakota | [NAME] |  | 379 | 0 | 379 |  | Mirella |  | Mirella |  | Booked | Unpaid (Fee) | Booking Fee |  | 53
Spreadsheet: 722482d1615293393-formula-to-pick-up-most-recent-date-against-reference-code-document-index
Sheet: Index Summary

 | Last Updated | Ref | Project | Total Capital Value (£'000) | Total Revenue Value (£'000)
 |  | PR00A-01 | Document A1
 |  | PR00B-02 | Document B2
 |  | PR00B-03 | [NAME]
 |  | PR00B-08 | [NAME]
 |  | PR00J-09 | Document J9
 |  | PR00X-07 | Document X7
 |  | PR00X-07 | [NAME]
 |  | PR00X-15 | Document X15
 |  | PR00X-16 | [NAME]
Spreadsheet: 203701d1357227366-link-data-in-worksheets-add-deduct-formulas-as-criteria-are-arent-met-attendance-template-excel
Sheet: August

Employee Absence Schedule
August | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | CI | T | NCNS | Total Points
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5
Spreadsheet: 00c9f2fa-fe84-4433-a569-c770fd6362bc
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
FPGO | Test | FPGO | Anaplasma phagocytophilum Antibodies (IgG, IgM) | Anaplasma phagocytophilum IgG, IgM | Immunofluorescence Assay (IFA) | Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Spin down and separate. Ship 1 mL of serum refrigerate.  Note: Serum gel tube is acceptable, but must pour off into             plastic vial. | 0.2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | IgG  <1:64 IgM  <1:20  Anaplasma phagocytophilum is the tick-borne agent causing Human Granulocytic Ehrlichiosis (HGE). HGE is distinct and separate from Human Monocytic Ehrlichiosis (HME), caused by Ehrlichia chaffeensis. Serologic crossreactivity between A. phagocytophilum and E. chaffeensis is minimal (5-15%).  Test Performed By:  Focus Diagnostics, Inc.                                        5785 Corporate Ave.                                        Cypress, CA  90630-4750 | Monday through Saturday | 1-3 days | 3-5 days | 2 | 86666 |  |  |  |  | Focus Diagnositics, Inc.
FPGO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 5 days
FPGO | Result | Z2276 | A. phagocytophilum IgG | A. phagocytophilum IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23877-4 | Anaplasma phagocytophilum Ab.[NAME]:Titr:Pt:Ser:Qn:IF
FPGO | Result | Z2277 | A. phagocytophilum IgM | A. phagocytophilum IgM | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23878-2 | Anaplasma phagocytophilum Ab.IgM:Titr:Pt:Ser:Qn:IF
FPGO | Result | Z2278 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 4cd71066-92ab-403b-82ad-03ac67b5e31f
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
PNZN | Test | PNZN | Perphenazine, (Trilafon), Serum | Perphenazine (Trilafon) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 3 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s).  ([NAME] is not acceptable.)  Spin down and send 3 mL sodium heparin plasma refrigerated  in amber vial (Supply T192) to protect from light. Note:	1. Indicate plasma on request form.             	2.  [NAME] specimen appropriately (plasma).                 3. Trough levels are most reproducible  Serum Draw blood in a plain, red-top tube(s).  (Serum gel tube is not acceptable.)  Spin down and send 3 mL of serum refrigerated  in amber vial (Supply T192) to protect from light. Note:		1. Indicate serum on request form. 		2. Label specimen appropriately (serum). 		3. Trough levels are most reproducible | 0.3 mL NOTE: Submission of the m | Specimens other than	Plasma, serum Anticoagulants other than	EDTA, heparin, plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range: 5.0-30.0 ng/mL   Low-dose therapeutic range for Perphenazine: 0.5-2.5 ng/mL   Test Performed By  Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Friday | 5 days | 7 - 9 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
PNZN | Result | Z1052 | Perphenazine | Perphenazine | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: eric_saibi__9769__012502R
Sheet: Encina 04

Owner Name |  | Cabrillo Power LLC
Station Name |  | Encina Power Station
Unit Name |  | Encina 04
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas
Capacity |  | 306 MW
Start Date |  | 2002-01-12 00:00:00
End Date |  | 2002-01-30 00:00:00
Prv. Start Date |  | 2002-01-12 00:00:00
Prv. End Date |  | 2002-01-25 00:00:00
Comments |  | Inspection
SIC |  | 4931
Plant ID |  | 1013264
Unit ID |  | 1006367
Outage ID |  | 19471
Spreadsheet: 767660c2-728a-4f3c-9964-ca5dec434db9
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of Sep. 8 - Sep. 12
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2008-09-08 00:00:00 | 2008-09-08 00:00:00 | 2008-09-08 00:00:00 | 2008-09-10 00:00:00 | 2008-09-10 00:00:00 | 2008-09-10 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems |  |  |  |  |  | Poor spin, no spare
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2008-09-08 00:00:00 | 2008-09-08 00:00:00 | 2008-09-08 00:00:00 | 2008-09-10 00:00:00 | 2008-09-10 00:00:00 | 2008-09-10 00:00:00 | - | - | -
 | Top (A) | 10287 | 17255 | 73561 | 10182 | 16936 | 30501 | - | - | -
 | Center (A) | 10254 | 17224 | 73250 | 10165 | 16937 | 30298 | - | - | -
 | Flat (A) | 10264 | 17219 | 73570 | 10209 | 16945 | 30465 | - | - | -
 | Left  (A) | 10278 | 17225 | 73777 | 10201 | 16942 | 30424 | - | - | -
 | Right (A) | 10278 | 17226 | 73485 | 10222 | 16952 | 30761 | - | - | -
 | Average (A) | 10272.2 | 17229.8 | 73528.6 | 10195.8 | 16942.4 | 30489.8 | - | - | -
 | [NAME]  (A) | 13.08434178715079 | 14.34224529103024 | 189.7269090039437 | 22.50999777883108 | 6.503845017520092 | 169.8578817719322 | - | - | -
 | Comments
Exposure | Date (Exposure) | 2008-09-08 00:00:00 | 2008-09-08 00:00:00 | 2008-09-08 00:00:00 | 2008-09-10 00:00:00 | 2008-09-10 00:00:00 | 2008-09-10 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.1s | 1.4s | 3.0s x2 | 1.1s | 1.4s | 3.0s
 | Problems
SVG                            Developer | Date (Develop) | 2008-09-08 00:00:00 | 2008-09-08 00:00:00 | 2008-09-08 00:00:00 | 2008-09-10 00:00:00 | 2008-09-10 00:00:00 | 2008-09-10 00:00:00
 | Track | 2 | 2 | 2 | 1 | 1 | 1
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2008-09-08 00:00:00 | 2008-09-08 00:00:00 | 2008-09-08 00:00:00 | 2008-09-10 00:00:00 | 2008-09-10 00:00:00 | 2008-09-10 00:00:00
 | Top (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 2.5/2 | 1.5/2 | 2/1.5 | 2.5/2.5
 | Center (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 2/2 | 1.5/1.5 | 1.5/2 | 2.5/3
 | Flat (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 2/2 | 1.5/1.5 | 1.5/2 | 2.5/2.5
 | Left (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 2.5/2 | 1.5/1.5 | 2/1.5 | 2/1.5
 | Right (H/V) (um) | 1/1.5 | 1.5/1.5 | 2/2 | 1.5/1.5 | 1.5/2 | 1.5/1.5
 | Comments | slight overexp. | L.E.R. | Lifting | L.E.R.
Spreadsheet: 811381d1672456417-need-formula-to-calculate-average-state-total-fuel-expense-and-price-per-gallon-average-sample1-3-
Sheet: Sheet1

Type | Amount | State | PPG |  | Arizona Amount Average
Diesel | 170.54 | AZ | 5.12 |  | Diesel
DEF | 25.32 | AZ | 3.99 |  | DEF
DEF | 32.54 | CA | 3.99
DEF | 41.21 | CA | 3.99 |  | California Amount Average
Diesel | 109.56 | CA | 5.08 |  | Diesel
DEF | 19.09 | AZ | 3.97 |  | DEF
Diesel | 220.89 | AZ | 5.11
Diesel | 210.27 | AZ | 5.15 |  | Average PPG
DEF | 25.75 | AZ | 3.95 |  | Diesel | depending of the answers in post #2
Diesel | 178.12 | AZ | 5.01 |  | DEF | depending of the answers in post #2
Diesel | 164.02 | CA | 5.64
Diesel | 225.09 | AZ | 5.12
Diesel | 179.01 | CA | 5.15
Diesel | 190.09 | AZ | 5.1
DEF | 29.01 | AZ | 5.01
Diesel | 371.01 | CA | 5.5
DEF | 39.04 | CA | 5.49
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 1032
2002-02-28 00:00:00
CBS Volume
 |  |  | 487
Spreadsheet: 715170d1611591620-comparing-values-in-2-4-columns-example_formula
Sheet: Formula Jungle

Obs. 1 | Obs. 2 | Obs. 3 | Obs. 4 | if >1 apart |  |  |  |  | Obs. 1 | Obs. 2 | Obs. 3 | Obs. 4
1 | 2 | 3 | 3 | ! | (1 and 3 are more than 1 apart) |  |  |  | 1 | 2 | 5 | 2
3 | 2 | 3 | 2 |  |  |  |  |  | 4 | 3 | 4
3 | 4 | 2 |  | ! | <- without formula |  |  |  | 3 | 5 | 4 | 5 |  | <- Formula can be placed here :)
4 | 2 |  |  | ! | (4 >1 apart from 2) |  |  |  | 2 | 4 | 3
5 | 4 |  |  |  |  |  |  |  | 4 | 3
 |  |  |  |  |  |  | 1. It does not have to be an exclamation point but some elegant way to signal, that the values are more than 1 value apart. 2. The table if possible should be dynamic so that if I have values for 2 then it will only look at those two, for 3 then all three, etc. 3. Reason being, that sometimes only 2 observations are recorded while other times I have 4. The values always range from 1-5.
My Attempt for 2 Columns:
1 | 2
4 | 3
2 | 4 |  | <- with formula
1 | 2
2 | 4
My bad Attempt for 3 Columns:
1 | 2 | 3
2 | 5 | 3
4 | 4 | 4 |  | <- with formula
2 | 4 | 2
3 | 4 | 3
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 6

Fixtures | Week 6 |  |  |  |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] |  | - |  | Leicester City |  | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 2 | 0 | 2 | 2 | 0 | 2 | 2 | 2 | 2
Bournemouth |  | - |  | Everton |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0
Liverpool |  | - |  | Hull City |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Middlesbrough |  | - |  | Tottenham |  | 0 | 2 | 2 | 5 | 2 | 0 | 0 | 2 | 0 | 2 | 5 | 2 | 2 | 2 | 0 | 2 | 5 | 2 | 2 | 2
Stoke City |  | - |  | West Brom |  | 0 | 5 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0
Sunderland |  | - |  | Crystal Palace |  | 2 | 2 | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2
Swansea City |  | - |  | Manchester City |  | 5 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 5 | 2 | 0 | 2 | 2 | 5 | 2 | 2
Arsenal |  | - |  | Chelsea |  | 0 | 2 | 0 | 0 | 2 | 0 | 2 | 2 | 0 | 2 | 2 | 0 | 2 | 0 | 2 | 2 | 0 | 2 | 0 | 0
West Ham |  | - |  | Southampton |  | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 2
Burnley |  | - |  | Watford |  | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0
Home Team | Score |  |  | Away Team | Weekly Total
[NAME] | 4 | - | 1 | Leicester City |  | 2-1 | 2-1 | 0-1 | 2-1 | 2-1 | 2-1 | 2-0 | 1-0 | 2-1 | 2-0 | 2-2 | 2-0 | 1-2 | 3-2 | 2-1 | 2-2 | 3-1 | 2-1 | 2-0 | 3-1
Bournemouth | 1 | - | 0 | Everton |  | 0-1 | 1-2 | 1-2 | 1-3 | 1-3 | 0-2 | 0-2 | 1-1 | 1-0 | 1-2 | 1-2 | 1-1 | 1-3 | 1-1 | 2-1 | 0-2 | 1-1 | 1-3 | 1-2 | 0-2
Liverpool | 5 | - | 1 | Hull City |  | 3-0 | 3-1 | 4-1 | 2-0 | 4-1 | 3-1 | 4-1 | 2-0 | 3-1 | 3-0 | 3-0 | 2-1 | 5-0 | 3-1 | 2-1 | 2-0 | 3-0 | 2-0 | 3-0 | 3-1
Middlesbrough | 1 | - | 2 | Tottenham |  | 2-1 | 0-1 | 0-2 | 1-2 | 0-2 | 1-1 | 1-0 | 0-1 | 1-1 | 0-2 | 1-2 | 0-2 | 0-1 | 0-1 | 2-1 | 1-3 | 1-2 | 0-2 | 0-1 | 0-3
Stoke City | 1 | - | 1 | West Brom |  | 2-0 | 1-1 | 1-2 | 0-2 | 1-1 | 1-2 | 0-1 | 1-0 | 2-1 | 1-2 | 1-1 | 1-0 | 2-0 | 1-1 | 2-1 | 1-2 | 2-0 | 0-2 | 2-1 | 1-2
Sunderland | 2 | - | 3 | Crystal Palace |  | 1-2 | 1-2 | 1-2 | 2-2 | 1-2 | 0-1 | 0-0 | 2-1 | 2-1 | 1-0 | 0-2 | 2-2 | 1-1 | 0-1 | 2-1 | 1-2 | 2-1 | 1-2 | 1-1 | 0-2
Swansea City | 1 | - | 3 | Manchester City |  | 1-3 | 1-4 | 0-3 | 1-4 | 0-3 | 1-2 | 0-5 | 0-2 | 0-3 | 0-3 | 0-3 | 1-4 | 1-3 | 0-2 | 2-1 | 1-4 | 0-2 | 1-3 | 0-3 | 1-4
Arsenal | 3 | - | 0 | Chelsea |  | 2-2 | 3-2 | 1-2 | 2-2 | 2-1 | 2-2 | 2-0 | 2-1 | 2-2 | 2-1 | 3-2 | 1-1 | 2-1 | 1-1 | 2-1 | 2-1 | 2-2 | 2-0 | 1-2 | 1-2
West Ham | 0 | - | 3 | Southampton |  | 1-1 | 1-1 | 1-2 | 1-2 | 1-1 | 1-1 | 0-0 | 2-2 | 1-1 | 1-0 | 1-1 | 1-2 | 2-1 | 1-2 | 2-1 | 0-2 | 1-1 | 2-0 | 2-0 | 1-2
Burnley | 2 | - | 0 | Watford |  | 1-2 | 1-2 | 0-1 | 1-1 | 1-2 | 1-2 | 1-0 | 1-2 | 2-1 | 0-2 | 2-1 | 1-1 | 2-1 | 2-2 | 2-1 | 1-1 | 1-1 | 0-2 | 1-2 | 0-2
Spreadsheet: 273484d1382724544-array-formulas-book1
Sheet: Summary

October 2013 [NAME]
Facility | # Parts | # [NAME]'s | Total $
X1
1X
XX
Totals
SOLD
Avoidance%
Yes I am aware of the div/0 error, I was in kind of a hurry to put this together. All of these  facility sheets normally have data on them though so this setup is not currently an issue
Spreadsheet: 102265d1300227372-random-item-number-equals-correct-price-new-job-template-1
Sheet: Final Payment

INVOICE
For Customer: |  |  |  |  |  | From: |  | Terms | Final Payment
Name:
Address:
City: |  |  |  |  |  |  |  | Work Order#
Phone:
Fax: |  |  |  |  |  |  |  | Date
Phase/Date |  | Description |  |  |  |  |  |  | Price
TOTAL DUE:
We Appreciate Your Prompt Payment.
Spreadsheet: 871732d1718162393-unique-sum-with-multiple-criteria-tests2
Sheet: Sheet1

Date | Particulars | Group | Code | Message No | Quantity | Value
2025-03-19 00:00:00 | Los Angesles | Ref New | 23027 | [PHONE] | 619.66 | 189705
 | Scented Polythene Clay |  |  |  | 119.48 | 34649.2
 | Scented Polythene Clay |  |  |  | 500.18 | 155055.8
2025-03-19 00:00:00 | United Foods (P) Ltd.Teslki | Ref New | 23028 | 503583857 | 1320 | 264000
 | [NAME] |  |  |  | 1320 | 264000
2025-03-19 00:00:00 | Indigo & Chemical Industries Pvt Ltd | Ref New | 23029 | 373564926 | 325.26 | 118719.9
 | Scented Adhesive Powder |  |  |  | 325.26 | 118719.9
2025-03-19 00:00:00 | [NAME].Ltd, | Ref New | 23030 | 814738835 | 238.3 | 94128.5
 | Scented & Adhesive Clay |  |  |  | 238.3 | 94128.5
2025-03-19 00:00:00 | [NAME],MPS | Ref New | 23031 | 606887140 | 851.2 | 157472
 | [NAME] |  |  |  | 851.2 | 157472
2025-03-19 00:00:00 | Pioushataka Ltd.Ukoloosna | Ref New | 23032 | 990036362 | 14760.3 | 1850203.6
 | Freight |  |  |  | 7380.15 | 36900.75
 | [NAME] |  |  |  | 7380.15 | 1813302.85
2024-03-14 00:00:00 | World Biscuits & Confectioanry Pvt Ltd,Greenand | Ref New | 46918 | 506235437 | 689.79 | 337997.1
 | Scented Adhesive Powder |  |  |  | 250.29 | 122642.1
 | Scented Adhesive Powder |  |  |  | 439.5 | 215355
2024-03-29 00:00:00 | M.G Foods  Pvt.Ltd,Deparasi | [NAME] | 67B | 300010282
2024-04-04 00:00:00 | Lily Milk & Beverage Ind. Pvt.Ltd | [NAME] | 68 | 606643050 |  | 4049.5
 | [NAME] |  |  |  |  | 4049.5
2024-04-04 00:00:00 | Mailuni Capetwon | [NAME] | 69 | 300099360 | 118.3 | 42152
 | Desten & Biber |  |  |  | 88.3 | 38852
 | [NAME] |  |  |  | 30 | 3300
2024-03-18 00:00:00 | World Biscuits & Confectioanry Pvt Ltd,Greenand | Whatsapp Note | 19 | 600285537 |  | 12788.76
 | Scented Adhesive Powder |  |  |  |  | 12788.76
2024-04-04 00:00:00 | Mailuni Capetwon | Ref New | 69 | 300099360 | 118.3 | 42152
 | Papa |  |  |  | 88.3 | 38852
 | [NAME] |  |  |  | 30 | 3300
2025-03-19 00:00:00 | United Foods (P) Ltd.Teslki | [NAME] | 23028 | 503583857 | 1320 | 264000
 | Laila Majnu |  |  |  | 1320 | 264000
2025-03-19 00:00:00 | [NAME] | Whatsapp Note | 526 | 625634 |  | 656344
 | My Forum |  |  |  |  | 551
Spreadsheet: 85558d1285654369-count-entries-at-each-change-in-data-sample-file
Sheet: Sheet1

COL-A | COL-B | COL-C | COL-D | COL-E | Desired result
A | Mercedes | [NAME] | Executive Management | 0 | Zero or blank, preferably blank
B | Caprice | [NAME] | Executive Management | 0 | Zero or blank, preferably blank |  | Row Labels | Count of COL-D
B | Caprice | [NAME] | Executive Management | 0 | Zero or blank, preferably blank |  | Asset Development | 4
B | Caprice | [NAME] | Executive Management | 0 | Zero or blank, preferably blank |  | Executive Management | 6
C | GM LS | Ronny | Executive Management | 0 | Zero or blank, preferably blank |  | Grand Total | 10
D | GM GS | [NAME] | Executive Management | 6 | Total of Executive Management
C | GM LS | [NAME] | Asset Development | 0 | Zero or blank, preferably blank
D | GM GS | [NAME] | Asset Development | 0 | Zero or blank, preferably blank
D | GM LS | Jo | Asset Development | 0 | Zero or blank, preferably blank
D | GM GS | [NAME] | Asset Development | 4 | Total of Asset Development
I need a formula that I can write in cell E1 and drag down, that should count all entries from column D but show only the final count as in the example.  Hope this makes sense and someone can help me out.