tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 107796d1304951781-locate-multiplier-competitive-price-matching
Sheet: THHNGRID

[NAME] AND CABLE
April 12, 2011 (041211)
THHN
 | [NAME] | NET | 1 | 1.25 | 2 | 2.25 | 3 | 3.25 | 4 | 4.25 | 5 | 5.25 | 6 | 6.25 | 7 | 7.25 | 7.25 + 1/2 | 7.25 +1 | 7.25 + 1 1/2 | 7.25 + 2 | 8 | 8.25 | 9 | 9.25 | 10 | 10.25 | 11 | 11.25 | 12 | 12.25 | 13 | 13.25 | 14 | 14.25 | 15 | 15.25 | 16 | 16.25 | 17 | 17.25 | 18 | 18.25 | 19 | 19.25 | 20 | 20.25 | 21 | 21.25 | 22 | 22.25 | 23 | 23.25 | 24 | 24.25 | 25 | 25.25 | 26 | 26.25 | 27 | 27.25 | 28 | 28.25 | 29 | 29.25 | 30 | 30.25 | 31 | 31.25 | 32 | 32.25 | 33 | 33.25 | 34 | 34.25 | 35 | 35.25 | 36
MULT'R | MFT | 1 | 0.95 | 0.9263 | 0.9025 | 0.8799 | 0.8574 | 0.8359 | 0.8145 | 0.7941 | 0.7738 | 0.7544 | 0.7351 | 0.7167 | 0.6983 | 0.6809 | 0.6775 | 0.6741 | 0.6707 | 0.6673 | 0.6634 | 0.6468 | 0.6303 | 0.6145 | 0.5987 | 0.5837 | 0.5688 | 0.5546 | 0.5404 | 0.5269 | 0.5133 | 0.5005 | 0.4876 | 0.4754 | 0.4632 | 0.4516 | 0.44 | 0.429 | 0.418 | 0.4076 | 0.3971 | 0.3872 | 0.3772 | 0.3678 | 0.3583 | 0.3493 | 0.3404 | 0.3319 | 0.3234 | 0.3153 | 0.3072 | 0.2995 | 0.2918 | 0.2845 | 0.2772 | 0.2703 | 0.2633 | 0.2567 | 0.2501 | 0.2438 | 0.2376 | 0.2317 | 0.2257 | 0.2201 | 0.2145 | 0.2091 | 0.2038 | 0.1987 | 0.1936 | 0.1888 | 0.1839 | 0.1793 | 0.1747 | 0.1703 | 0.166 | 0.1619 | 0.1577
18 STR TFFN | 8 | 128.29
16 STR TFFN | 10 | 175.49
14 SOLID | 16 | 189.79
12 SOLID | 24 | 286.33
10 SOLID | 37 | 452.68
14 STR | 17 | 216.4
12 STR | 25 | 331.96
10 STR | 40 | 512.94
8 STR | 65 | 774.78
6 STR | 99 | 1192.07
4 STR | 159 | 1877.6
3 STR | 203 | 2363.92
2 STR | 243 | 2966.7
1 STR | 301 | 3882.42
1/0 STR | 387 | 4705.62
2/0 STR | 482 | 5898.68
3/0 STR | 599 | 7399.97
4/0 STR | 747 | 9292.61
250 MCM | 891 | 11021.2
300 MCM | 1060 | 13150.36
350 MCM | 1229 | 15397.79
400 MCM | 1396 | 17525.33
500 MCM | 1731 | 21806.02
600 MCM | 2087 | 28262.18
750 MCM | 2588 | 47589.82
1000 MCM |  | 63153.68
Spreadsheet: 72789d1273519676-pivot-table-row-data-dont-show-agentdontshow1
Sheet: Sheet1

system | TL | Agents
W | A | X1
U | B | X2 |  |  | system | TL | Agents
W | C | X3 |  |  | U | B | X10
U | D | X4 |  |  |  |  | X14
W | A | X5 |  |  |  |  | X2
U | B | X6 |  |  |  |  | X6
W | C | X7 |  |  |  | B Total
U | D | X8 |  |  |  | D | X12
W | A | X9 |  |  |  |  | X16
U | B | X10 |  |  |  |  | X4
W | C | X11 |  |  |  |  | X8
U | D | X12 |  |  |  | D Total
W | A | X13 |  |  | U Total
U | B | X14 |  |  | W | A | X1
W | C | X15 |  |  |  |  | X13
U | D | X16 |  |  |  |  | X5
 |  |  |  |  |  |  | X9
 |  |  |  |  |  | A Total
 | Like this |  |  |  |  | C | X11
 |  |  |  |  |  |  | X15
System | TL | Agents |  |  |  |  | X3
U | B |  |  |  |  |  | X7
 | D |  |  |  |  | C Total
W | A |  |  |  | W Total
 | C |  |  |  | Grand Total
Spreadsheet: 45239d1244026954-formula-to-calculate-totals-from-three-different-sheets-top-performer
Sheet: Mar

[NAME] | EXRM175 | 268
[NAME] | EXBR103 | 209
Bridget Mohale | [NAME] | 207
[NAME] | ABNMAD3 | 204
Kamo C Maripane | EXKM193 | 201
Theresa Khela | EXTK127 | 195
[NAME] | EXCM146 | 192
[NAME] | EXCM134 | 179
[NAME] | EXNM104 | 179
[NAME] | ABLH285 | 176
[NAME] | EXZR100 | 170
[NAME] | EXNK128 | 170
[NAME] | EXPM225 | 165
Phindile Ndhlovu | EXPN130 | 157
ankie Pitse | ABLP420 | 156
[NAME] | EXNM105 | 155
Monchu Ntswane | ABMN629 | 152
[NAME] | EXSK133 | 150
[NAME] | ABMMBKY | 147
[NAME] | ABMMBAO | 146
Mase Letseleha | EXML129 | 143
Michelle Damons | ABMD419 | 141
[NAME] | EXRK111 | 141
[NAME] | ABCW433 | 140
[NAME] | EXLM103 | 135
Matshidiso Kganyago | EXMK126 | 131
Tumi Glodean Mekwa | EXGM103 | 130
Sibusiso Sibeko | EXSS139 | 127
Tahlitah Mosia | EXMM409 | 127
Musiwalo [NAME] | EXMT148 | 120
[NAME] | ABBT137 | 119
[NAME] | EXJT108 | 118
Phuti Mangaba | EXPM226 | 117
[NAME] | EXLL119 | 112
Lindiwe Maepa | ABFM329 | 104
Dikeledi Shuping | EXDS116 | 63
[NAME] | ABNMADZ | 58
[NAME] | ABDV180 | 55
[NAME] | ABTR217 | 31
Veronique Legoabe | EXVL104 | 21
[NAME] | EXSW110 | 21
[NAME] | ABJL464 | 15
[NAME] | ABRS621 | 9
Spreadsheet: e0410cd4-ea2a-43fa-8a6b-ffef31e690cf
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
FHUAB | Test | FHUAB | [NAME] with [NAME] to [NAME] and Western Blot | [NAME] with Reflex | Immunofluorescence Assay (IFA) Western Blot (WB) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red top tube. Spin down and send 0.5 mL of serum ambient. Note: 1. Overnight fasting is preferred. 2. Serum gel tube is acceptable but must pour off into a plastic vial. | 0.2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | [NAME], IFA, Serum   Reference Range: Negative   Neuronal nuclear ([NAME]) antibody is present in patients with various neurological symptoms including two paraneoplastic syndromes: sensory neuropathy (PSN) and encephalomyelitis (PEM). The presence of [NAME] antibody strongly suggests underlying small cell lung carcinoma (SCLC). [NAME] antibody is identified by IFA and confirmed by Western Blot. A negative result does not exclude the possibility of SCLC or other malignant tumor.   [NAME], Western Blot, Serum   Reference Range: Negative   Hu Ab Titer, Serum   Reference Range: <1:40   Test Performed by: Quest Diagnostics Nichols Institute                               33608 [NAME]                               San Juan Capistrano, CA 92690-6130 | Monday, Wednesday, Friday | 4 days | 6-10 days | 1 | 86255 |  |  |  |  | Quest Diagnostics/Nichols Institute
FHUAB | [NAME] | SERUM | Serum |  |  |  | Ambient | 7 days
FHUAB | Result | Z2518 | [NAME], IFA, Serum | [NAME], IFA, Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHUAB | [NAME] | FHUWB | [NAME], Serum | [NAME], Western Blot, Serum | Western Blot (WB) |  |  |  |  |  | Only orderable as a reflex from FHUAB See FHUAB Hu Antibody Screen |  |  | Only orderable as a reflex from FHUAB See FHUAB Hu Antibody Screen |  |  |  | 1 | 84181 |  |  | No | No
FHUWB | [NAME] | SERUM | Serum |  |  |  | Ambient | 7 days
FHUWB | Result | FHUWB | [NAME], Western Blot, Serum | [NAME], Western Blot, Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FHUAB | [NAME] | FHUAT | [NAME], Serum | [NAME], Serum | Immunofluorescence Assay (IFA) |  |  |  |  |  | Only orderable as a reflex to FHUAB See FHUAB Hu Antibody Screen |  |  | Only orderable as a reflex from FHUAB See FHUAB Hu Antibody Screen |  |  |  | 1 | 86256 |  |  | No | No
FHUAT | [NAME] | SERUM | Serum |  |  |  | Ambient | 7 days
FHUAT | Result | FHUAT | [NAME], Serum | [NAME], Serum | Numeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 152546d1335433581-need-help-in-solving-excel-task-assignment3
Sheet: StudyPlan

Code | Studies | Min CP
G | General studies | 15
GO | General studies optional | 9
B | Basic studies | 50
C | Core studies | 70
S | Special studies | 8
SO | Special studies optional | 12
F | Free choice courses | 8
T | Graduation thesis | 8
 | TOTAL | 180
Spreadsheet: 0597a74b-2934-4438-8646-62c6feff6082
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | FIRE  PROTECTION  SYSTEM  MODIFICATION  PERMIT  LOG | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Form Number/Rev # CFM-00009-F2 R3 | Unnamed: 13 | Unnamed: 14
FIRE  PROTECTION  SYSTEM  MODIFICATION  PERMIT  LOG
Permit No. | Date Permit Opened | Bldg. | [NAME]. Zone # | Work Type | Work Description | Owner | Part 1 | Part 2 |  |  |  |  | Date Permit Closed | Notes
 |  |  |  |  |  |  | Design Review Complete | Insp/Test Reports Accepted | Fire Alarm Program Updated | Fire Alarm Graphics Updated | Contractor As-builts Accepted | Facility As-builts Updated
29 | 2010-10-29 00:00:00 | NFE |  |  | False fire alarms |  |  | 1 hour |  |  |  | MWG | 2010-11-19 00:00:00 | repeat of item #2. Closure with item #2.
30 | 2010-11-09 00:00:00 | NFN |  |  | Exhaust flucutations |  |  | 10 minutes |  |  |  | P. O'Dea | 2010-12-10 00:00:00 | Replace cogged pulleys and belts when parts are available.  Stock cogged pulleys. Fans to be taken off line 'manually' in the future.
31 | 2010-11-22 00:00:00 | NFC |  |  | Damage trestle pipe |  |  | ? |  |  |  | MWG | 2010-12-28 00:00:00 | Piping repaired and transition made on 1-10-11.                                 1) Follow written procedures for system start up. Do not deviate without input from others.                    2) Verify operation/position of control valves during design verification.
32 | 2010-11-22 00:00:00 | NFN |  |  | Extended DIW system down time due to control wiring issues |  |  | 1 hr. vs. 5 hrs. |  |  |  | MWG | 2010-12-17 00:00:00 | 1) Verify wire labeling performed.   2) Improve communication between CM & subs.
33 | 2010-11-22 00:00:00 | NFN |  |  | High dissolved O2 levels |  |  | 2 hrs. vs. 15 hrs. |  |  |  | [NAME] | 2010-11-23 00:00:00 | Prolonged DO levels likely due to air trapped in system. Bleed or verify no trapped air in the future.
 |  |  |  | Printed copies are considered uncontrolled.  Verify revision prior to use.
DCN0971 |  |  |  | CNSE Confidential When Completed |  |  |  |  |  |  |  | Page 1 of 1
Spreadsheet: 162310d1339790496-vlookup-and-if-statement-question-example-cunninja4-oeldere2-
Sheet: Sheet1

2012-02-14 00:00:00 | As of                       10-Feb-12 | 2012-02-28 00:00:00 | 2012-03-13 00:00:00 | As of 7-Mar-12 | 2012-03-27 00:00:00 | 2012-04-10 00:00:00 | 2012-04-24 00:00:00 | 2012-05-08 00:00:00 | As of           10-Apr-12 | 2012-05-22 00:00:00 | 2012-06-05 00:00:00 | 2012-06-19 00:00:00 |  | helpcolum |  | without helpcolum |  |  |  |  | wanted
 |  |  | 12 |  |  |  | 2 |  |  | 0 |  |  |  | 3 | 0 |  | 0 |  | 2 |  | 0
 |  | 6 |  |  |  |  |  | 5 |  |  |  |  |  | 2 | 5 |  | 5 |  | 5 |  | 5
 |  |  |  |  |  |  | 18 |  |  |  |  |  |  | 1 | 18 |  | 18 |  | 18 |  | 18
Spreadsheet: 88683d1288522917-need-to-find-a-way-to-validate-and-double-check-my-data-finderrorsver2
Sheet: Sheet2

Heading 1 | Heading 2
f | no
a | no
m | yes
c | yes
n | no
d | yes
l | yes
a | no
g | yes
f | yes
e | yes
g | yes
a | yes
h | no
j | no
Spreadsheet: 204664d1357598676-general-database-problems-to-make-it-more-user-friendly-excel-practice-hjii-oeldere-
Sheet: Sheet2

 | Vlook up table
 | Program | Building | Classroom
 | Business | B | 12
 | English lit. | A | 15
 | Maths | C | 42
 | Chemistry | D | 4
 | Biology | D | 5
 | Physics | D | 23
Spreadsheet: scott_neal__38601__hurricaneranks
Sheet: Sheet1

 |  | UPDATED May 15, 2001
 | HURRICANE SUPPLY/MARKET RANKING
 | 1)  Please make sure you are ranked for May noms forward
 | 2) Rank according to this schedule unless your trader says otherwise
 | 3)  Same zone priority ranking between counterparties is up to the
 | discretion of the trader
 | RANKING FROM LOWEST PRIORITY TO HIGHEST PRIORITY
 |  | A)  Storage injections
 |  | B)  Day interruptible
 |  | C)  Baseload interruptible
 |  | D)  Term interruptible
 |  | E)  Day firm
 |  | F)  Baseload firm
 |  | G)  Baseload EFP
 |  | H)  [NAME] (with swing rights)
 |  | I)   Term firm
 |  | J )  Term EFP
 | Note:  Desk to Desk is day by day
 | Note:  Devise creative ways to avoid getting cut
 | Note:  [NAME]/EOL deals are baseload firm and day firm
 | Note: Ranks change from day to day
Spreadsheet: 58895d1259174433-sumproduct-dummy
Sheet: Nov

2009 November [NAME]
Loan Officer | Processed | Approved | Declined | Cross Sales | Cross Sell Product | Cross Sell % | Total Closed | MTG's | MFT'D | 2ND's | AUTO'S
A | 2 | 2 | 0 | 3 |  | 0 | #N/A | 1 | 0 | 0 | 2
B | 1 | 1 | 0 | 5 |  | 0 | #N/A | 0 | 1 | 0 | 0
C | 1 | 1 | 0 | 2 |  | 0 | #N/A | 0 | 0 | 1 | 0
D | 1 | 0 | 1 | 2 |  | 0 | #N/A | 1 | 0 | 0 | 0
E | 1 | 0 | 1 | 7 |  | 0 | #N/A | 0 | 0 | 0 | 1
 |  |  |  |  |  | #N/A | #N/A | 0 | 0 | 0 | 0
TOTALS | 6 | 4 | 2 | 19 | 0 | #N/A | #N/A | 2 | 1 | 1 | 3
Client Name | Loan Officer | MTG Amt | MFT'D Amt | HELOC/2nd's Amt | Auto Amt | Approve/Dec | # of Cross Sales | Prod | Prod | Prod | Prod
[NAME], [NAME] | A | 100000 |  |  | 20000 | Approved | 2 | Chk | Sav | OB | OS
Smith, George | B |  | 120000 |  |  | Approved | 5 | Chk | OS
Smith, [NAME] | C |  |  | 80000 |  | Approved | 2 | OB
Smith, [NAME] | A |  |  |  | 5000 | Approved | 1 | LN | Sav
Smith, [NAME] | E |  |  |  | 9785.14 | Declined | 7 | BP | OB
[NAME], [NAME] | D | 250000 |  |  |  | Declined | 2 | LN | Chk | Sav | MM
 |  | Cell F4 should display 6 since loan officer A had a total of 6 products sold(look in cells
 |  | I13:J76 for products sold)
 |  | What is this formula?
Spreadsheet: 219539d1362777615-closest-match-cross-reference-table-ghozi-09032013-closest-match-cross-reference-table
Sheet: Sheet1

 |  | 0.5 | 0.95 | 1.3 | 1.5 |  | 7550
 | 2000 | 52.23947650256464 | 53.93181480784878 | 45.92479187687872 | 86.44988009132628 |  | 0.95
 | 4000 | -100.552265896826 | 89.26643984394089 | 14.90914841147374 | 80.34175281274239
 | 4300 | 81.22154796136577 | -81.52123008462407 | 110.5962445700372 | 6.768984914800749 |  |  | result
 | 5500 | 34.10949560135847 | 40.97441818965368 | -23.02460310582478 | 10.92890510852874
 | 7000 | 74.7643388535746 | 35.67452029420289 | 60.48390374847121 | 46.02914503250342
 | 8000 | -81.45123965597064 | 42.39578261908683 | 27.96758974507652 | 80.3776503689813
 | 8850 | 60.70480196791742 | 22.02008050498643 | -37.75107431354807 | -6.144331890133125
 | 10000 | 19.7993306464823 | 99.82267933174433 | 21.09540076727095 | 30.51503959823486
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-6D

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-16 00:00:00
 |  |  | Monitoring Well #: | MW-6D |  |  |  | Well Depth: | 45.28 |  | ft |  |  | Screened/Open Interval: | 20 - 45 |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 23 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 1.16 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 12:25 | x |  | 7.13 | NA | 16.29 | NA | 1370 | NA | 0.54 | NA | 95.1 | NA | 3.93 | NA | 220 | 0
 | 12:30 | x |  | 7.14 |  | 16.38 |  | 1367 |  | 0.28 |  | 102 |  | 3.47 |  | 220 | 0
 | 12:35 | x |  | 7.12 |  | 16.39 |  | 1371 |  | 0.3 |  | 107.6 |  | 4.55 |  | 220 | 0
 | 12:40 | x |  | 7.1 |  | 16.38 |  | 1382 |  | 0.34 |  | 110.8 |  | 3.91 |  | 220 | 0
 | 12:45 | x |  | 7.1 |  | 16.32 |  | 1388 |  | 0.2 |  | 112.6 |  | 4.06 |  | 220 | 0
 | 12:50 | x |  | 7.1 |  | 16.39 |  | 1407 |  | 0.14 |  | 114.4 |  | 2.32 |  | 220 | 0
 | 12:55 | x |  | 7.11 |  | 16.32 |  | 1418 |  | 0.15 |  | 117.6 |  | 2.25 |  | 220 | 0
 | 13:00 | x |  | 7.11 |  | 16.28 |  | 1424 |  | 0.14 |  | 119.1 |  | 2.13 |  | 220 | 0
 | [NAME]: |  | 12:16:00 |  | Sample notes:
 | [NAME]: |  | 13:00:00
 | Sample Time: |  | 13:02:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 88259d1288124229-autopopulate-linked-worksheets-11-november-2010
Sheet: JE sheet

PAYABLE TO: |  |  |  |  | CONTROL #
 |  |  |  |  | Posting Date:
 |  |  |  |  | VENDOR #
PARTICULARS |  |  |  |  |  | AMOUNT
*All amounts shown below should be charged exactly as they are to each
company.
ACCOUNT CODES |  |  | NET | GST | PST | TOTAL | CODE
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
 | 1.[PHONE]
Date Prepared: |  | 2010-10-26 00:00:00
Approved by: |  |  |  | Treasurer
Spreadsheet: f7ecf6b2-f37f-489d-aa1b-3e3840bb4657
Sheet: Sheet1

U.S. imports and exports of selected fertilizers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Country | Year | Commodity | U.S. exports |  | U.S. imports
 |  |  | Short tons | Dollars | Short tons | Dollars
World total | 2012 | Total | 10783383.12829999 | 4524425576 | 35552394.81829984 | 12971781552
 |  | Ammonium Nitrate (Solid) | 369361.9909 | 107094247 | 938283.2715 | 251160833
 |  | Ammonium Sulfate | 1428243.4962 | 361485882 | 274619.3059 | 72519921
 |  | Anhydrous Ammonia | 41503.79960000001 | 21683794 | 6938743.7101 | 3593224143
 |  | Aqua Ammonia | 6548.764300000002 | 4033848 | 96517.388 | 14936072
 |  | Calcium Cyanamide | 0 | 0 | 0 | 0
 |  | Calcium Nitrate | 0 | 0 | 42493.66500000001 | 4785433
 |  | Chemical Mixtures | 476065.7332000007 | 259592057 | 218462.6324000001 | 121785817
 |  | Concentrated Super | 91.4909 | 358240 | 230239.6056 | 98343771
 |  | Diammonium Phosphate (DAP) | 3997434.732700001 | 1738700734 | 101105.1606 | 48837281
 |  | Monammonium Phosphate (MAP) | 2653544.744000002 | 1276755340 | 546706.6286999995 | 282340085
 |  | Nitrogen Solutions | 157721.4932 | 42504849 | 3286246.204900001 | 877224364
 |  | Normal Super | 16204.9123 | 10527099 | 1595.0281 | 328557
 |  | Other [NAME] | 29576.9136 | 11222401 | 462435.7937000002 | 72941441
 |  | Other Phosphate Fertilizers | 0 | 0 | 0 | 0
 |  | Other Potassium Fertilizers | 0 | 0 | 0 | 0
 |  | Phosphate Rock | 42240.13600000001 | 1382790 | 2819510.338900001 | 368608270
 |  | [NAME], Superphosphoric | 58781.2498 | 46656429 | 5526.9322 | 2532906
 |  | [NAME], Wet Process | 868524.2159999999 | 312708478 | 2253.1012 | 534045
 |  | Potassium Muriate | 173378.5624 | 76305026 | 9215293.0357 | 3474511463
 |  | Potassium Nitrate | 17356.8158 | 11424279 | 175415.6128 | 119776444
 |  | Potassium Sulfate | 72420.0077 | 30052312 | 118081.6829 | 55106650
 |  | Potassium-Sodium Nitrate | 0 | 0 | 583.1167 | 263409
 |  | Sodium Nitrate | 3690.5004 | 2825331 | 164132.47 | 67228136
 |  | Sulfur | 0 | 0 | 2259686.3402 | 234183653
 |  | Urea (Solid) | 370693.5693 | 209112440 | 7654463.7932 | 3210608858
Note: Blank cells indicate no data are available. Generally, data for U.S. exports (quantity) are available beginning in 1990, export value data are available beginning in 2008. U.S. import data (both quantity and value) are available from 1995 forward. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics; and ERS calculations using Census trade statistics.
Contacts: [NAME] and [NAME]
Spreadsheet: 67451d1268080715-multiple-criteria-for-sumproduct-example
Sheet: Sheet1

Bucket Type | PM | Schedule Type
Base | N/A | DETAIL
Base | Blank | FUNCT
Transco | [NAME] | DETAIL
Transco | [NAME] | DETAIL
Path | [NAME] | BASIC
Base | [NAME] | BASIC
I am looking for a formula that will look for the word "BASE" in column A and looks for "N/A" and or "Blank" in column B.  Then it totals how many are "DETAIL" and "Funct" from column C
It needs to total: 2 (items in red)
They are "Base" and "N/A" and or "Blank" and equal detail and funct
Spreadsheet: 866913d1713822395-average-ifs-within-a-targeted-range-example
Sheet: Sheet1

 | 2023 |  |  |  |  | 2022 |  |  |  |  | 2023 chg
 | Revenue | OI | EBITDA | EPS |  | Revenue | OI | EBITDA | EPS |  | Revenue | OI | EBITDA | EPS
BUNNY | 957.672 | 167.958 | 201.321 | 9.92 | 9.92 | 904.739 | 154.428 | 189.128 | 9.24
BEAR | 800.9 | -14.8 | 180.7 | 0.34 | 0.34 | 717.8 | -200 | -123.3 | 0.37
[NAME] | 3433.763 | 50000 | 193.236 | 1.27 |  | 2613.399 | 106.038 | 157.863 | 1.54
LIOn | 794.045 | 56.301 | 89.192 | 0.63 |  | 546.259 | 15.138 | 50.384 | 0.28
Spreadsheet: bc4bf249-3b08-40c9-97bd-5d363516dc3d
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
EHRCP | Test | EHRCP | Ehrlichia Antibody Panel, Serum | Ehrlichia Ab Panel | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Heat-inactivated specimen | <1:64 | Monday through Friday; 9 a.m. | Same day/1 day | 3 days |  | Profile |  |  |  |  | Rochester
EHRCP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EHRCP | Component | ANAP | Anaplasma phagocytophilum (Human Granulocytic Ehrlichiosis) Antibody, Serum | Anaplasma phagocytophilum Ab, IgG,S | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <1:64 | Monday through Friday; 9 a.m. | 1 day | 3 days | 1 | 86666 |  |  | Yes | Yes
ANAP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ANAP | Result | 81157 | Anaplasma phagocytophilum Ab, IgG,S | Anaplasma phagocytophilum Ab, IgG,S | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 23877-4
EHRCP | Component | EHRC | Ehrlichia chaffeensis (HME) Antibody, IgG, Serum | Ehrlichia Chaffeensis (HME) Ab, IgG | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Heat-inactivated specimen | <1:64 | Monday through Friday; 9 a.m. | Same day/1 day | 3 days | 1 | 86666 |  |  | Yes | Yes
EHRC | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EHRC | Result | 81478 | Ehrlichia Chaffeensis (HME) Ab, IgG | Ehrlichia Chaffeensis (HME) Ab, IgG | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 47405-6
Spreadsheet: 180410d1347582466-multiple-criteria-lookup-listing-unique-information-book1
Sheet: Data Input

Input Data |  |  |  |  |  | Output |  |  |  |  | Output
Name | Date | Score |  |  |  | Name | Date | Score |  |  | Name | Score
[NAME] | 2012-09-01 00:00:00 | 89
[NAME] | 2012-09-01 00:00:00 | 93
[NAME] | 2012-09-01 00:00:00 | 75
Zoe | 2012-09-01 00:00:00 | 50
[NAME] | 2012-09-01 00:00:00 | 60
[NAME] | 2012-09-02 00:00:00 | 85
[NAME] | 2012-09-02 00:00:00 | 76
[NAME] | 2012-09-02 00:00:00 | 90
Zoe | 2012-09-02 00:00:00 | 90
[NAME] | 2012-09-02 00:00:00 | 70
[NAME] | 2012-09-03 00:00:00 | 50
[NAME] | 2012-09-03 00:00:00 | 48
[NAME] | 2012-09-03 00:00:00 | 93
Zoe | 2012-09-03 00:00:00 | 88
[NAME] | 2012-09-03 00:00:00 | 84
[NAME] | 2012-09-04 00:00:00 | 76
[NAME] | 2012-09-04 00:00:00 | 90
[NAME] | 2012-09-04 00:00:00 | 52
[NAME] | 2012-09-04 00:00:00 | 60
Zoe | 2012-09-04 00:00:00 | 80
[NAME] | 2012-09-05 00:00:00 | 90
Zoe | 2012-09-05 00:00:00 | 97
[NAME] | 2012-09-05 00:00:00 | 99
[NAME] | 2012-09-05 00:00:00 | 89