SUMIF Prior 3 months

Geo1126

New Member
Joined
Apr 15, 2019
Messages
9
Greetings Excel Wizards.

I'm trying to figure out how to make a SUMIF formula work based on the prior 3 months of the current month (excluding the current month). I have hundreds of parts with hundreds of shipments on my source data sheet (a shipping log). on a separate table I have a single line per part that totals my various data. I want to be add a data collect for those prior 3 months and have been stumped on how to do it.

I'm maybe a set up from complete novice with excel, and everything I've learned thus far has been self taught. Can't get this one going. I apologize if this has already been covered, i did spend a little time searching for the answer.

here is a very basic example. This assumes the current date is in April. Thus it excludes the April and December dates from desired results. Only want Prior 3 months, Jan/Feb/Mar. I hope this makes sense, and I truly appreciate any help on this. lets say Part Number is column A, Date is B and QTY is C

SOURCE DATA
Part #Date ShippedQTY
112/20/20182,658
112/21/20183,697
112/29/20181,000
21/1/20191,254
21/1/20191,234
21/2/20191,254
31/2/20191,698
31/5/2019542
31/10/2019429
22/10/20194,258
12/10/2019251
12/10/20193,269
12/11/2019258
22/12/2019654
22/12/2019111
32/12/201912,569
12/15/20193,254
22/15/20197,826
32/15/20192,596
42/15/20194,245
13/1/20194,269
23/1/20193,249
13/1/20199,215
23/1/20192,150
33/1/20192,301
43/1/20196,580
33/15/20193,291
33/15/20191,928
23/15/20192,397
23/15/20194,528
24/10/20192,015
14/10/20191,025

<tbody>
</tbody>

DESIRED RESULTS
PartTotal shippedPrior 3 months
128,89620,516
230,93028,915
325,35425,354
410,82510,825

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,766
Office Version
365
Platform
Windows
How about

<b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">Part #</td><td style=";">Date Shipped</td><td style=";">QTY</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Part</td><td style=";">Total shipped</td><td style=";">Prior 3 months</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;;">1</td><td style="text-align: right;;">29/12/2018</td><td style="text-align: right;;">1,000</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">1</td><td style="text-align: right;;">28,896</td><td style="text-align: center;;">20516</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: right;;">2</td><td style="text-align: right;;">01/01/2019</td><td style="text-align: right;;">1,254</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">2</td><td style="text-align: right;;">30,930</td><td style="text-align: center;;">28915</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: right;;">2</td><td style="text-align: right;;">01/01/2019</td><td style="text-align: right;;">1,234</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">3</td><td style="text-align: right;;">25,354</td><td style="text-align: center;;">25354</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: right;;">2</td><td style="text-align: right;;">02/01/2019</td><td style="text-align: right;;">1,254</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">4</td><td style="text-align: right;;">10,825</td><td style="text-align: center;;">10825</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: right;;">3</td><td style="text-align: right;;">02/01/2019</td><td style="text-align: right;;">1,698</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style="text-align: right;;">3</td><td style="text-align: right;;">05/01/2019</td><td style="text-align: right;;">542</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style="text-align: right;;">3</td><td style="text-align: right;;">10/01/2019</td><td style="text-align: right;;">429</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style="text-align: right;;">2</td><td style="text-align: right;;">10/02/2019</td><td style="text-align: right;;">4,258</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="text-align: right;;">1</td><td style="text-align: right;;">10/02/2019</td><td style="text-align: right;;">251</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style="text-align: right;;">1</td><td style="text-align: right;;">10/02/2019</td><td style="text-align: right;;">3,269</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style="text-align: right;;">1</td><td style="text-align: right;;">11/02/2019</td><td style="text-align: right;;">258</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style="text-align: right;;">2</td><td style="text-align: right;;">12/02/2019</td><td style="text-align: right;;">654</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style="text-align: right;;">2</td><td style="text-align: right;;">12/02/2019</td><td style="text-align: right;;">111</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style="text-align: right;;">3</td><td style="text-align: right;;">12/02/2019</td><td style="text-align: right;;">12,569</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style="text-align: right;;">1</td><td style="text-align: right;;">15/02/2019</td><td style="text-align: right;;">3,254</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style="text-align: right;;">2</td><td style="text-align: right;;">15/02/2019</td><td style="text-align: right;;">7,826</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: center;;"></td></tr></tbody></table><p style="width:3.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">List</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H5</th><td style="text-align:left">=SUMPRODUCT(<font color="Blue">(<font color="Red">MONTH(<font color="Green">$B$5:$B$34</font>)>=MONTH(<font color="Green">TODAY(<font color="Purple"></font>)</font>)-3</font>)*(<font color="Red">MONTH(<font color="Green">$B$5:$B$34</font>)<MONTH(<font color="Green">TODAY(<font color="Purple"></font>)</font>)</font>)*(<font color="Red">$A$5:$A$34=F5</font>),$C$5:$C$34</font>)</td></tr></tbody></table></td></tr></table><br />
 
Last edited:

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,382
Office Version
365
Platform
Windows
I'm trying to figure out how to make a SUMIF formula work based on the prior 3 months
Hi, here is an alternative option that uses SUMIFS()

<b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">Part #</td><td style=";">Date Shipped</td><td style=";">QTY</td><td style="text-align: right;;"></td><td style=";">Part</td><td style=";">Total shipped</td><td style=";">Prior 3 months</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;">1</td><td style="text-align: right;;">12/20/2018</td><td style="text-align: right;;">2,658</td><td style="text-align: right;;"></td><td style="text-align: right;;">1</td><td style="text-align: right;background-color: #FFFF00;;">28,896</td><td style="text-align: right;background-color: #FFFF00;;">20516</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;">1</td><td style="text-align: right;;">12/21/2018</td><td style="text-align: right;;">3,697</td><td style="text-align: right;;"></td><td style="text-align: right;;">2</td><td style="text-align: right;;">30,930</td><td style="text-align: right;;">28915</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;">1</td><td style="text-align: right;;">12/29/2018</td><td style="text-align: right;;">1,000</td><td style="text-align: right;;"></td><td style="text-align: right;;">3</td><td style="text-align: right;;">25,354</td><td style="text-align: right;;">25354</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;;">2</td><td style="text-align: right;;">01/01/2019</td><td style="text-align: right;;">1,254</td><td style="text-align: right;;"></td><td style="text-align: right;;">4</td><td style="text-align: right;;">10,825</td><td style="text-align: right;;">10825</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: right;;">2</td><td style="text-align: right;;">01/01/2019</td><td style="text-align: right;;">1,234</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: right;;">2</td><td style="text-align: right;;">01/02/2019</td><td style="text-align: right;;">1,254</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: right;;">3</td><td style="text-align: right;;">01/02/2019</td><td style="text-align: right;;">1,698</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: right;;">3</td><td style="text-align: right;;">01/05/2019</td><td style="text-align: right;;">542</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style="text-align: right;;">3</td><td style="text-align: right;;">01/10/2019</td><td style="text-align: right;;">429</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style="text-align: right;;">2</td><td style="text-align: right;;">02/10/2019</td><td style="text-align: right;;">4,258</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style="text-align: right;;">1</td><td style="text-align: right;;">02/10/2019</td><td style="text-align: right;;">251</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="text-align: right;;">1</td><td style="text-align: right;;">02/10/2019</td><td style="text-align: right;;">3,269</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style="text-align: right;;">1</td><td style="text-align: right;;">02/11/2019</td><td style="text-align: right;;">258</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style="text-align: right;;">2</td><td style="text-align: right;;">02/12/2019</td><td style="text-align: right;;">654</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style="text-align: right;;">2</td><td style="text-align: right;;">02/12/2019</td><td style="text-align: right;;">111</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style="text-align: right;;">3</td><td style="text-align: right;;">02/12/2019</td><td style="text-align: right;;">12,569</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style="text-align: right;;">1</td><td style="text-align: right;;">02/15/2019</td><td style="text-align: right;;">3,254</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style="text-align: right;;">2</td><td style="text-align: right;;">02/15/2019</td><td style="text-align: right;;">7,826</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style="text-align: right;;">3</td><td style="text-align: right;;">02/15/2019</td><td style="text-align: right;;">2,596</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">21</td><td style="text-align: right;;">4</td><td style="text-align: right;;">02/15/2019</td><td style="text-align: right;;">4,245</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">22</td><td style="text-align: right;;">1</td><td style="text-align: right;;">03/01/2019</td><td style="text-align: right;;">4,269</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">23</td><td style="text-align: right;;">2</td><td style="text-align: right;;">03/01/2019</td><td style="text-align: right;;">3,249</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">24</td><td style="text-align: right;;">1</td><td style="text-align: right;;">03/01/2019</td><td style="text-align: right;;">9,215</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">25</td><td style="text-align: right;;">2</td><td style="text-align: right;;">03/01/2019</td><td style="text-align: right;;">2,150</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">26</td><td style="text-align: right;;">3</td><td style="text-align: right;;">03/01/2019</td><td style="text-align: right;;">2,301</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">27</td><td style="text-align: right;;">4</td><td style="text-align: right;;">03/01/2019</td><td style="text-align: right;;">6,580</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">28</td><td style="text-align: right;;">3</td><td style="text-align: right;;">03/15/2019</td><td style="text-align: right;;">3,291</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">29</td><td style="text-align: right;;">3</td><td style="text-align: right;;">03/15/2019</td><td style="text-align: right;;">1,928</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">30</td><td style="text-align: right;;">2</td><td style="text-align: right;;">03/15/2019</td><td style="text-align: right;;">2,397</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">31</td><td style="text-align: right;;">2</td><td style="text-align: right;;">03/15/2019</td><td style="text-align: right;;">4,528</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">32</td><td style="text-align: right;;">2</td><td style="text-align: right;;">04/10/2019</td><td style="text-align: right;;">2,015</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">33</td><td style="text-align: right;;">1</td><td style="text-align: right;;">04/10/2019</td><td style="text-align: right;;">1,025</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">F2</th><td style="text-align:left">=SUMIFS(<font color="Blue">C:C,A:A,E2</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">G2</th><td style="text-align:left">=SUMIFS(<font color="Blue">C:C,A:A,E2,B:B,">="&EOMONTH(<font color="Red">TODAY(<font color="Green"></font>),-4</font>)+1,B:B,"<="&EOMONTH(<font color="Red">TODAY(<font color="Green"></font>),-1</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
 

Geo1126

New Member
Joined
Apr 15, 2019
Messages
9
Hi, here is an alternative option that uses SUMIFS()


Worksheet Formulas
CellFormula
F2=SUMIFS(C:C,A:A,E2)
G2=SUMIFS(C:C,A:A,E2,B:B,">="&EOMONTH(TODAY(),-4)+1,B:B,"<="&EOMONTH(TODAY(),-1))

<tbody>
</tbody>

<tbody>
</tbody>
oh man... i was soooo close to this one. Thank you also FormR! you are a rockstar!
 

Watch MrExcel Video

Forum statistics

Threads
1,095,752
Messages
5,446,294
Members
405,395
Latest member
anilals

This Week's Hot Topics

Top