Calculate units by multiple criteria

M

Moe2886

New Member
Joined
Mar 29, 2018
Messages
2
Hi all, Happy Friday!
I was asked to work out a formula based on multiple conditions and for the life of me I can't work it out. I think I'm over complicating it but I was thinking an INDEX and MATCH formula would work. I know I can just do a simple lookup to get the results but in all honesty I've never seen data stored like this and if I have, I would just use a PIVOT.

In short this was what was asked of me: Show how many Units were sold for the year 2017


[TABLE="width: 500"]
<tbody>[TR]
[TD]Variable[/TD]
[TD]Jan17[/TD]
[TD]Feb17[/TD]
[TD]Mar17[/TD]
[TD]Apr17[/TD]
[TD]Jun17[/TD]
[TD]Jul17[/TD]
[TD]Aug17[/TD]
[TD]Sep17[/TD]
[TD]Oct17[/TD]
[TD]Nov17[/TD]
[TD]Dec17[/TD]
[TD]Jan18[/TD]
[TD]Feb18[/TD]
[/TR]
[TR]
[TD]Traffic[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]3,322[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]3,488[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,592[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]3,007[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]18,325[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]16,431[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,783[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]1,933[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,388[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,405[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]3,538[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,988[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]3,047[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Traffic[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]3,846[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,138[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]5,467[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]1,225[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,788[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]1,926[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]5,988[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,450[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]1,700[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,983[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,100[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,900[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl67, width: 63, align: right"]2,450[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Units[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]548[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]566[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]1,420[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]541[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]581[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]535[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]560[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]387[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]541[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]541[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]866[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]560[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]400[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Units[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]1,420[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]541[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]1,420[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]387[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]1,420[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]541[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]560[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]571[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]387[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]560[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]541[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]362[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]162[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Gross Rev[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5,805.36[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5,247.24[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,175.64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£1,716.56[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,026.92[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£4,717.35[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£1,663.83[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£1,808.98[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,258.34[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£3,354.40[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£4,096.14[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,479.86[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,455.90[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Gross Rev[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,175.64[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,795.24[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£3,285.30[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,455.90[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£3,354.40[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£3,324.45[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5,247.24[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£1,999.58[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,270.21[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£3,354.40[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,327.67[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£2,026.92[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£1,826.95[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Avg Price[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£4.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£4.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£1.49[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£6.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£4.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£3.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£4.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£3.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Avg Price[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£4.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£1.49[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£1.49[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£4.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£4.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£4.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£3.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£3.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 63"]
<tbody>[TR]
[TD="class: xl66, width: 63, align: right"]£5.99[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Anyway hopefully I can sleep at night knowing either I was on the right track with INDEX or I'm a complete fool :)
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
Try this

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Variable</td><td style="text-align:right; ">ene-17</td><td style="text-align:right; ">feb-17</td><td style="text-align:right; ">mar-17</td><td style="text-align:right; ">abr-17</td><td style="text-align:right; ">may-17</td><td style="text-align:right; ">jun-17</td><td style="text-align:right; ">jul-17</td><td style="text-align:right; ">ago-17</td><td style="text-align:right; ">sep-17</td><td style="text-align:right; ">oct-17</td><td style="text-align:right; ">nov-17</td><td style="text-align:right; ">dic-17</td><td style="text-align:right; ">ene-18</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Traffic</td><td style="text-align:right; ">3,322</td><td style="text-align:right; ">3,488</td><td style="text-align:right; ">2,592</td><td style="text-align:right; ">3,007</td><td style="text-align:right; ">18,325</td><td style="text-align:right; ">16,431</td><td style="text-align:right; ">2,783</td><td style="text-align:right; ">1,933</td><td style="text-align:right; ">2,388</td><td style="text-align:right; ">2,405</td><td style="text-align:right; ">3,538</td><td style="text-align:right; ">2,988</td><td style="text-align:right; ">3,047</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >Traffic</td><td style="text-align:right; ">3,846</td><td style="text-align:right; ">2,138</td><td style="text-align:right; ">5,467</td><td style="text-align:right; ">1,225</td><td style="text-align:right; ">2,788</td><td style="text-align:right; ">1,926</td><td style="text-align:right; ">5,988</td><td style="text-align:right; ">2,450</td><td style="text-align:right; ">1,700</td><td style="text-align:right; ">2,983</td><td style="text-align:right; ">2,100</td><td style="text-align:right; ">2,900</td><td style="text-align:right; ">2,450</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Units</td><td style="text-align:right; ">548</td><td style="text-align:right; ">566</td><td style="text-align:right; ">1,420</td><td style="text-align:right; ">541</td><td style="text-align:right; ">581</td><td style="text-align:right; ">535</td><td style="text-align:right; ">560</td><td style="text-align:right; ">387</td><td style="text-align:right; ">541</td><td style="text-align:right; ">541</td><td style="text-align:right; ">866</td><td style="text-align:right; ">560</td><td style="text-align:right; ">400</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Units</td><td style="text-align:right; ">1,420</td><td style="text-align:right; ">541</td><td style="text-align:right; ">1,420</td><td style="text-align:right; ">387</td><td style="text-align:right; ">1,420</td><td style="text-align:right; ">541</td><td style="text-align:right; ">560</td><td style="text-align:right; ">571</td><td style="text-align:right; ">387</td><td style="text-align:right; ">560</td><td style="text-align:right; ">541</td><td style="text-align:right; ">362</td><td style="text-align:right; ">162</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >Variable</td><td >Year</td><td >Result</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >Units</td><td style="text-align:right; ">2017</td><td style="text-align:right; ">16356</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C8</td><td >=SUMPRODUCT((A2:A5=A8)*(YEAR(B1:N1)=B8)*(B2:N5))</td></tr></table></td></tr></table>
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top