mojo300

Active Member
Joined
Apr 18, 2006
Messages
301
Am I able to do the following?
you're welcome

Ok,
So now I need a sumifs formula to add all the Sq. Ft. based on multiple criteria, Columns A and C. I tried the sumifs formula and I just couldnt get the numbers to add up correctly. Any help would be appreciated. THanks I did the first one manually

<b></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 /></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></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Type</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Number of Sites</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">State</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Sq. Ft.</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: center;border-top: 1px solid black;;">Double Park</td><td style="text-align: center;border-top: 1px solid black;;">8</td><td style="text-align: center;border-top: 1px solid black;;">OH</td><td style="text-align: center;border-top: 1px solid black;;">439500</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">35</td><td style="text-align: center;;">OH</td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: center;;">Single Park</td><td style="text-align: center;;">5</td><td style="text-align: center;;">OH</td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">9</td><td style="text-align: center;;">PA</td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">44</td><td style="text-align: center;;">PA</td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: center;;">Single Park</td><td style="text-align: center;;">2</td><td style="text-align: center;;">PA</td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">7</td><td style="text-align: center;;">FL</td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">55</td><td style="text-align: center;;">FL</td><td style="text-align: center;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style="text-align: center;;">Single Park</td><td style="text-align: center;;">0</td><td style="text-align: center;;">FL</td><td style="text-align: center;;"></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)">B2</th><td style="text-align:left">=COUNTIFS(<font color="Blue">Sheet3!A2:A166,A2:A10,Sheet3!C2:C166,C2</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B3</th><td style="text-align:left">=COUNTIFS(<font color="Blue">Sheet3!A3:A167,A3:A11,Sheet3!C3:C167,C3</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B4</th><td style="text-align:left">=COUNTIFS(<font color="Blue">Sheet3!A4:A168,A4:A12,Sheet3!C4:C168,C4</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B5</th><td style="text-align:left">=COUNTIFS(<font color="Blue">Sheet3!A5:A169,A5:A13,Sheet3!C5:C169,C5</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B6</th><td style="text-align:left">=COUNTIFS(<font color="Blue">Sheet3!A6:A170,A6:A14,Sheet3!C6:C170,C6</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B7</th><td style="text-align:left">=COUNTIFS(<font color="Blue">Sheet3!A7:A171,A7:A15,Sheet3!C7:C171,C7</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B8</th><td style="text-align:left">=COUNTIFS(<font color="Blue">Sheet3!A8:A172,A8:A16,Sheet3!C8:C172,C8</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B9</th><td style="text-align:left">=COUNTIFS(<font color="Blue">Sheet3!A9:A173,A9:A17,Sheet3!C9:C173,C9</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B10</th><td style="text-align:left">=COUNTIFS(<font color="Blue">Sheet3!A10:A174,A10:A18,Sheet3!C10:C174,C10</font>)</td></tr></tbody></table></td></tr></table><br />

This is the sheet where the numbers would come from
<b></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 /></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></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Type</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Sq. Ft.</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">State</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: center;border-top: 1px solid black;;">Double Park</td><td style="text-align: center;border-top: 1px solid black;;">32536</td><td style="text-align: center;border-top: 1px solid black;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">156160</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">29040</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">15345</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">56139</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">69700</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">7450</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">73130</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">7913</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">10686</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">19200</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">11520</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">49541</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">11744</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">13130</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">6132</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">43771</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">17444</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">905</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">21</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">70089</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">22</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">36147</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">23</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">15517</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">24</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">11790</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">25</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">16131</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">26</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">38287</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">27</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">12725</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">28</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">7922</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">29</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">26250</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">30</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">29738</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">31</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">9268</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">32</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">16923</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">33</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">15423</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">34</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">9670</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">35</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">16192</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">36</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">26764</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">37</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">26486</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">38</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">7546</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">39</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">32604</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">40</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">12600</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">41</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">26664</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">42</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">11033</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">43</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">11620</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">44</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">10057</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">45</td><td style="text-align: center;;">Single Park</td><td style="text-align: center;;">65841</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">46</td><td style="text-align: center;;">Single Park</td><td style="text-align: center;;">5248</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">47</td><td style="text-align: center;;">Single Park</td><td style="text-align: center;;">1254</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">48</td><td style="text-align: center;;">Single Park</td><td style="text-align: center;;">9657</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">49</td><td style="text-align: center;;">Single Park</td><td style="text-align: center;;">33644</td><td style="text-align: center;;">OH</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">50</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">50805</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">51</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">19120</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">52</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">20731</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">53</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">191001</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">54</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">36655</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">55</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">16380</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">56</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">10548</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">57</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">14815</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">58</td><td style="text-align: center;;">Double Park</td><td style="text-align: center;;">50560</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">59</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">0</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">60</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">26370</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">61</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">21628</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">62</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">14746</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">63</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">22232</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">64</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">151298</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">65</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">21730</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">66</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">341400</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">67</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">30395</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">68</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">17846</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">69</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">0</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">70</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">23104</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">71</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">6609</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">72</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">27842</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">73</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">7497</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">74</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">5640</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">75</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">0</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">76</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">10424</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">77</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">17995</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">78</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">15682</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">79</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">8930</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">80</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">28144</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">81</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">1138</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">82</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">0</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">83</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">0</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">84</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">74662</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">85</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">930</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">86</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">24780</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">87</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">12904</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">88</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">55388</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">89</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">9666</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">90</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">6201</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">91</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">25896</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">92</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">16676</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">93</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">35115</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">94</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">19865</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">95</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">55467</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">96</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">0</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">97</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">26748</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">98</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">38524</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">99</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">0</td><td style="text-align: center;;">PA</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">100</td><td style="text-align: center;;">Triple Park</td><td style="text-align: center;;">8826</td><td style="text-align: center;;">PA</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)">Sheet3</p><br /><br />
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

mojo300

Active Member
Joined
Apr 18, 2006
Messages
301
YOUR 1ST TABLE SHOWS DOUBLE PARK / TRIPLE PARK AND STATE FL 7/55 WHERE AS IN SHEET 3 TABLE THERE ARE NONE

EXCEL SHEET IS ATTACHED


HOPE THIS HELPS YOU

REGARDS
MAHENDER LALWANI

You are correct as the MrExcel HTML Maker only allowed me to only copy a 100 lines, thats why the FL sites didnt carry over. I am fairly new to this, where are the formulas in the sheet you attached?
 

mojo300

Active Member
Joined
Apr 18, 2006
Messages
301
Never mid i downloaded the document and saw them. My only question is that on my spreadsheet I have two tabs and for whatever reason They just wouldn't add up right, I wonder if I have to put the info all on one tab.

Thank you for your help though
 

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,243
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows

ADVERTISEMENT

your formula should looks like

<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 /></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></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">Type</td><td style=";">Number of Sites</td><td style=";">State</td><td style=";">Sq. Ft.</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Double Park</td><td style="text-align: right;;">8</td><td style=";">OH</td><td style="text-align: right;background-color: #E2EFDA;;">439500</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Triple Park</td><td style="text-align: right;;">35</td><td style=";">OH</td><td style="text-align: right;background-color: #E2EFDA;;">689432</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">Single Park</td><td style="text-align: right;;">5</td><td style=";">OH</td><td style="text-align: right;background-color: #E2EFDA;;">115644</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">Double Park</td><td style="text-align: right;;">9</td><td style=";">PA</td><td style="text-align: right;background-color: #E2EFDA;;">410615</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">Triple Park</td><td style="text-align: right;;">44</td><td style=";">PA</td><td style="text-align: right;background-color: #E2EFDA;;">1212298</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">Single Park</td><td style="text-align: right;;">2</td><td style=";">PA</td><td style="text-align: right;background-color: #E2EFDA;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">Double Park</td><td style="text-align: right;;">7</td><td style=";">FL</td><td style="text-align: right;background-color: #E2EFDA;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">Triple Park</td><td style="text-align: right;;">55</td><td style=";">FL</td><td style="text-align: right;background-color: #E2EFDA;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">Single Park</td><td style="text-align: right;;">0</td><td style=";">FL</td><td style="text-align: right;background-color: #E2EFDA;;">0</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)">D2</th><td style="text-align:left">=SUMIFS(<font color="Blue">Sheet3!B:B,Sheet3!A:A,A2,Sheet3!C:C,C2</font>)</td></tr></tbody></table></td></tr></table><br />

in B2 and copy down
 

mojo300

Active Member
Joined
Apr 18, 2006
Messages
301
your formula should looks like

<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 /></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></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">Type</td><td style=";">Number of Sites</td><td style=";">State</td><td style=";">Sq. Ft.</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Double Park</td><td style="text-align: right;;">8</td><td style=";">OH</td><td style="text-align: right;background-color: #E2EFDA;;">439500</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Triple Park</td><td style="text-align: right;;">35</td><td style=";">OH</td><td style="text-align: right;background-color: #E2EFDA;;">689432</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style=";">Single Park</td><td style="text-align: right;;">5</td><td style=";">OH</td><td style="text-align: right;background-color: #E2EFDA;;">115644</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style=";">Double Park</td><td style="text-align: right;;">9</td><td style=";">PA</td><td style="text-align: right;background-color: #E2EFDA;;">410615</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">Triple Park</td><td style="text-align: right;;">44</td><td style=";">PA</td><td style="text-align: right;background-color: #E2EFDA;;">1212298</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">Single Park</td><td style="text-align: right;;">2</td><td style=";">PA</td><td style="text-align: right;background-color: #E2EFDA;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style=";">Double Park</td><td style="text-align: right;;">7</td><td style=";">FL</td><td style="text-align: right;background-color: #E2EFDA;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style=";">Triple Park</td><td style="text-align: right;;">55</td><td style=";">FL</td><td style="text-align: right;background-color: #E2EFDA;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">Single Park</td><td style="text-align: right;;">0</td><td style=";">FL</td><td style="text-align: right;background-color: #E2EFDA;;">0</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)">D2</th><td style="text-align:left">=SUMIFS(<font color="Blue">Sheet3!B:B,Sheet3!A:A,A2,Sheet3!C:C,C2</font>)</td></tr></tbody></table></td></tr></table><br />

in B2 and copy down

Thank you
 

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
4,243
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
you're welcome
 

Forum statistics

Threads
1,136,338
Messages
5,675,189
Members
419,553
Latest member
hanahass

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
Top