# Sumifs Formula

#### mojo300

##### Active Member
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

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.

#### Mahenderlalwani

##### New Member
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

#### mojo300

##### Active Member
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
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

in B2 and copy down

#### mojo300

##### Active Member

in B2 and copy down

Thank you

you're welcome

Replies
0
Views
204
Replies
2
Views
196
Replies
2
Views
224
Replies
2
Views
296
Replies
1
Views
311

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.

### Which adblocker are you using?

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

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