Spreadsheet: 699699d1602710391-use-a-calculated-field-to-reference-an-adjacent-cell-of-a-pivot-table-to-calculate-a-total-pending-diys
Sheet: Sheet1

Claimed by | DIY Recipe Cards Needed |  | # of DIYs |  | NMTs Per DIY | Paying |  | Row Labels | Count of Claimed by | NMTs Owed
[NAME] | apple chair |  | <10 | 0 | 0 | 0 NMT |  | [NAME] | 12
[NAME] | apple dress |  | 2020-10-19 00:00:00 | 10 | 3 |  |  | [NAME] | 8
[NAME] | apple hat |  | 20-29 | 20 | 4 |  |  | [NAME] | 42
[NAME] | apple rug |  | 30-49 | 30 | 5 |  |  | Fred | 1
[NAME] | Aquarius urn |  | 50+ | 50 | 6 |  |  | Grand Total | 63
[NAME] | armor shoes
[NAME] | backyard lawn
[NAME] | bamboo candleholder
[NAME] | bamboo drum |  | CALCULATE NMTS
[NAME] | bamboo hat |  | # of DIYs |  | NMTs Per DIY | Payment
[NAME] | bamboo partition |  | 15
[NAME] | bamboo speaker
[NAME] | bamboo stool |  |  |  | Adjacent Cell Formula
[NAME] | barbed-wire fence
[NAME] | barrel
[NAME] | basement flooring
[NAME] | birdcage
[NAME] | boomerang
[NAME] | brick well
[NAME] | [NAME]
[NAME] | butter churn
[NAME] | cabin wall
[NAME] | Capricorn ornament
[NAME] | cardboard bed
[NAME] | cardboard chair
[NAME] | cardboard sofa
[NAME] | cherry hat
[NAME] | cherry lamp
[NAME] | cherry umbrella
[NAME] | chocolate herringbone wall
[NAME] | clothesline
[NAME] | coconut juice
[NAME] | coconut wall planter
[NAME] | cosmos shower
[NAME] | cosmos wand
[NAME] | dark bamboo rug
[NAME] | dark wooden-mosaic wall
[NAME] | deer scare
[NAME] | destinations signpost
[NAME] | DIY workbench
[NAME] | document stack
[NAME] | doghouse
[NAME] | firewood
[NAME] | flower stand
[NAME] | frozen arch
[NAME] | frozen bed
[NAME] | [NAME]
[NAME] | frozen partition
[NAME] | frozen pillar
[NAME] | frozen sculpture
[NAME] | frozen table
[NAME] | frozen tree
[NAME] | frozen-treat set
[NAME] | fruit basket
[NAME] | garden wagon
[NAME] | giant teddy bear
[NAME] | gold armor
[NAME] | gold helmet
[NAME] | gold-armor shoes
[NAME] | golden casket
[NAME] | golden flooring
[NAME] | golden gears
Fred | golden seat
 | golden toilet
 | golden wand
 | green grass skirt
 | hanging terrarium
 | hedge
 | hedge standee
 | honeycomb flooring
 | honeycomb wall
 | hyacinth wand
 | ice flooring
 | ice wall
 | ice wand
 | imperial fence
 | iron doorplate
 | iron fence
 | iron frame
 | iron hanger stand
 | iron shelf
 | iron wall rack
 | iron wand
 | ironwood clock
 | ironwood cupboard
 | ironwood table
 | juicy-apple TV
 | jungle flooring
 | [NAME]
 | [NAME]
 | key holder
 | knight's helmet
 | knitted-grass backpack
 | leaf
 | leaf umbrella
 | lily record player
 | log bed
 | [NAME]
 | log decorative shelves
 | log dining table
 | [NAME] sofa
 | log round table
 | [NAME]-mounted clock
 | lucky gold cat
 | magazine rack
 | manga-library wall
 | manhole cover
 | [NAME]
 | medium cardboard boxes
 | modeling clay
 | money flooring
 | mossy garden rock
 | natural square table
 | oil-barrel bathtub
 | orange dress
 | orange hat
 | orange umbrella
 | outdoor bath
 | palm-tree lamp
 | pansy table
 | peach hat
 | peach wall
 | pear dress
 | plain wooden shop sign
 | [NAME]
 | pot
 | raccoon figurine
 | rocking horse
 | rose wand
 | rustic-stone wall
 | Sagittarius arrow
 | sandy-beach flooring
 | scarecrow
 | scattered papers
 | Scorpio lamp
 | shell arch
 | shell bed
 | shell lamp
 | shell partition
 | shell rug
 | shell speaker
 | shell stool
 | shell table
 | signpost
 | silo
 | simple well
 | simple wooden fence
 | snowflake wall
 | [NAME]
 | spiky fence
 | stacked magazines
 | stacked-wood wall
 | stall
 | steel-frame wall
 | stone arch
 | stone fence
 | stone tablet
 | stone wall
 | straw fence
 | straw umbrella hat
 | Taurus bathtub
 | tea table
 | three-tiered snowperson
 | tiny library
 | tree branch wreath
 | tree standee
 | tree-branch wand
 | [NAME]
 | tulip wand
 | unglazed dish set
 | vertical-board fence
 | wave breaker
 | wedding fence
 | wedding wand
 | windflower wand
 | wooden bookshelf
 | wooden bucket
 | wooden double bed
 | wooden mini table
 | wooden table
 | wooden table mirror
 | wooden waste [NAME]
 | wooden-block chest
 | wooden-block stool
 | wooden-block table
 | wooden-plank sign