Sum only certain cells in a column depending on values in another column

G

genius7

Board Regular
Joined
Oct 28, 2013
Messages
56
Hello everyone,

I'm struggling with a formula. In the table below is what I actually have in my worksheet. In the first column, the column to the extreme left (column A) there are various fruits categorized according to whether they are vegetables, fruits or nuts. In the table1, there are the same fruits but are not categorized. Further, in the table1 you can see how many units of each fruit were received during various months. Where there are no values it means that no fruit was received.
What I need to accomplish in the table2 is to have number of all the vegetables, fruits and nuts for each month.

For example, in the table2, in the vegetable row for January, there should be number 8 because only 8 units of vegetables were received during the month of January (2 carrots and 6 radishes).
Another example, in the nuts row for August, there should be number 18 because 18 units of nuts were received during the month of August (7 peanuts, 7 hazelnuts and 4 walnuts).
The important thing is that in the following months, like October, November and December I may add other vegetables, fruits and/or nuts to the column A and therefore also to the table1, thus augmenting the table1 (I would add additional rows).

I think that the formula, which goes to the table2 in order to give me the results I quoted in the examples, should first determine whether the fruit in the table1 is vegetable, fruits or nut. I tried to do that using SUMIF formula but without any success. Maybe this task require an advanced use of array formulas with which I am not very familiar.

Could you please help me with this problem? Please, bear in mind that I cannot change the structure of the tables nor of the column A.
Thank you very much in advance!



[TABLE="class: grid, width: 712"]
<tbody>[TR]
[TD]vegetable[/TD]
[TD][/TD]
[TD]table1[/TD]
[TD]January[/TD]
[TD]February[/TD]
[TD]March[/TD]
[TD]April[/TD]
[TD]June[/TD]
[TD]July[/TD]
[TD]August[/TD]
[TD]September[/TD]
[/TR]
[TR]
[TD]carrot[/TD]
[TD][/TD]
[TD]peanut[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]radish[/TD]
[TD][/TD]
[TD]apple[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD]turnip[/TD]
[TD][/TD]
[TD]banana[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]7[/TD]
[/TR]
[TR]
[TD]cucumber[/TD]
[TD][/TD]
[TD]carrot[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD]cabbage[/TD]
[TD][/TD]
[TD]radish[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]fruits[/TD]
[TD][/TD]
[TD]grape[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD][/TD]
[TD]hazelnut[/TD]
[TD][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD]pear[/TD]
[TD][/TD]
[TD]pear[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD]banana[/TD]
[TD][/TD]
[TD]raspberry[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]grape[/TD]
[TD][/TD]
[TD]walnut[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]raspberry[/TD]
[TD][/TD]
[TD]cucumber[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]nuts[/TD]
[TD][/TD]
[TD]cabbage[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD]hazelnut[/TD]
[TD][/TD]
[TD]turnip[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]walnut[/TD]
[TD][/TD]
[TD]coconut[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD]peanut[/TD]
[TD][/TD]
[TD]pine nut[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]coconut[/TD]
[TD][/TD]
[TD]total[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]52[/TD]
[TD="align: center"]47[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]52[/TD]
[TD="align: center"]58[/TD]
[TD="align: center"]52[/TD]
[/TR]
[TR]
[TD]pine nut[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]table2[/TD]
[TD]January[/TD]
[TD]February[/TD]
[TD]March[/TD]
[TD]April[/TD]
[TD]June[/TD]
[TD]July[/TD]
[TD]August[/TD]
[TD]September[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]vegetable[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]fruits[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]nuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Sort by date Sort by votes
maybe something like...

So as you add months you would just need to drag the formulas to the right to capture the column data above....essentially. The formulas not really referencing the column heading just where it is placed in the table. Hopefully that makes sense.

D21 =SUMPRODUCT(SUMIF($C$2:$C$16,$A$2:$A$6,D$2:D$16))
D22 =SUMPRODUCT(SUMIF($C$2:$C$16,$A$8:$A$12,D$2:D$16))
D23 =SUMPRODUCT(SUMIF($C$2:$C$16,$A$14:$A$18,D$2:D$16))

[TABLE="class: grid, width: 712"]
<TBODY>[TR]
[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]
[/TR]
[TR]
[TD]1
[/TD]
[TD]vegetable</SPAN>
[/TD]
[TD][/TD]
[TD]table1</SPAN>
[/TD]
[TD]January</SPAN>
[/TD]
[TD]February</SPAN>
[/TD]
[TD]March</SPAN>
[/TD]
[TD]April</SPAN>
[/TD]
[TD]June</SPAN>
[/TD]
[TD]July</SPAN>
[/TD]
[TD]August</SPAN>
[/TD]
[TD]September</SPAN>
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]carrot</SPAN>
[/TD]
[TD][/TD]
[TD]peanut</SPAN>
[/TD]
[TD]10</SPAN>
[/TD]
[TD]10</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]radish</SPAN>
[/TD]
[TD][/TD]
[TD]apple</SPAN>
[/TD]
[TD]8</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[TD]8</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]8</SPAN>
[/TD]
[TD]2</SPAN>
[/TD]
[TD]4</SPAN>
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]turnip</SPAN>
[/TD]
[TD][/TD]
[TD]banana</SPAN>
[/TD]
[TD]10</SPAN>
[/TD]
[TD]5</SPAN>
[/TD]
[TD]4</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[TD]8</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD]2</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]cucumber</SPAN>
[/TD]
[TD][/TD]
[TD]carrot</SPAN>
[/TD]
[TD]2</SPAN>
[/TD]
[TD]4</SPAN>
[/TD]
[TD]9</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]4</SPAN>
[/TD]
[TD]5</SPAN>
[/TD]
[TD]5</SPAN>
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]cabbage</SPAN>
[/TD]
[TD][/TD]
[TD]radish</SPAN>
[/TD]
[TD]6</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[TD]10</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]8</SPAN>
[/TD]
[TD]9</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]fruits</SPAN>
[/TD]
[TD][/TD]
[TD]grape</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]4</SPAN>
[/TD]
[TD]9</SPAN>
[/TD]
[TD]10</SPAN>
[/TD]
[TD]2</SPAN>
[/TD]
[TD]4</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]apple</SPAN>
[/TD]
[TD][/TD]
[TD]hazelnut</SPAN>
[/TD]
[TD][/TD]
[TD]5</SPAN>
[/TD]
[TD]2</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD]5</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]9</SPAN>
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]pear</SPAN>
[/TD]
[TD][/TD]
[TD]pear</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD]9</SPAN>
[/TD]
[TD]5</SPAN>
[/TD]
[TD]8</SPAN>
[/TD]
[TD]10</SPAN>
[/TD]
[TD]9</SPAN>
[/TD]
[TD]9</SPAN>
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]banana</SPAN>
[/TD]
[TD][/TD]
[TD]raspberry</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]7</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]grape</SPAN>
[/TD]
[TD][/TD]
[TD]walnut</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[TD]4</SPAN>
[/TD]
[TD]3</SPAN>
[/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD]raspberry</SPAN>
[/TD]
[TD][/TD]
[TD]cucumber</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2</SPAN>
[/TD]
[TD]0</SPAN>
[/TD]
[TD]1</SPAN>
[/TD]
[/TR]
[TR]
[TD]13
[/TD]
[TD]nuts</SPAN>
[/TD]
[TD][/TD]
[TD]cabbage</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5</SPAN>
[/TD]
[TD]2</SPAN>
[/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD]hazelnut</SPAN>
[/TD]
[TD][/TD]
[TD]turnip</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1</SPAN>
[/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD]walnut</SPAN>
[/TD]
[TD][/TD]
[TD]coconut</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5</SPAN>
[/TD]
[/TR]
[TR]
[TD]16
[/TD]
[TD]peanut</SPAN>
[/TD]
[TD][/TD]
[TD]pine nut</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17
[/TD]
[TD]coconut</SPAN>
[/TD]
[TD][/TD]
[TD]total</SPAN>
[/TD]
[TD]36</SPAN>
[/TD]
[TD]30</SPAN>
[/TD]
[TD]52</SPAN>
[/TD]
[TD]47</SPAN>
[/TD]
[TD]45</SPAN>
[/TD]
[TD]52</SPAN>
[/TD]
[TD]58</SPAN>
[/TD]
[TD]52</SPAN>
[/TD]
[/TR]
[TR]
[TD]18
[/TD]
[TD]pine nut</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19
[/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]
[TD]20
[/TD]
[TD][/TD]
[TD][/TD]
[TD]table2</SPAN>
[/TD]
[TD]January</SPAN>
[/TD]
[TD]February</SPAN>
[/TD]
[TD]March</SPAN>
[/TD]
[TD]April</SPAN>
[/TD]
[TD]June</SPAN>
[/TD]
[TD]July</SPAN>
[/TD]
[TD]August</SPAN>
[/TD]
[TD]September</SPAN>
[/TD]
[/TR]
[TR]
[TD]21
[/TD]
[TD][/TD]
[TD][/TD]
[TD]vegetable</SPAN>
[/TD]
[TD="align: right"]8</SPAN>
[/TD]
[TD="align: right"]5</SPAN>
[/TD]
[TD="align: right"]19</SPAN>
[/TD]
[TD="align: right"]10</SPAN>
[/TD]
[TD="align: right"]7</SPAN>
[/TD]
[TD="align: right"]14</SPAN>
[/TD]
[TD="align: right"]19</SPAN>
[/TD]
[TD="align: right"]10</SPAN>
[/TD]
[/TR]
[TR]
[TD]22
[/TD]
[TD][/TD]
[TD][/TD]
[TD]fruits</SPAN>
[/TD]
[TD]18</SPAN>
[/TD]
[TD]10</SPAN>
[/TD]
[TD]30</SPAN>
[/TD]
[TD]27</SPAN>
[/TD]
[TD]32</SPAN>
[/TD]
[TD]32</SPAN>
[/TD]
[TD]21</SPAN>
[/TD]
[TD]22</SPAN>
[/TD]
[/TR]
[TR]
[TD]23
[/TD]
[TD][/TD]
[TD][/TD]
[TD]nuts</SPAN>
[/TD]
[TD="align: right"]10</SPAN>
[/TD]
[TD="align: right"]15</SPAN>
[/TD]
[TD="align: right"]3</SPAN>
[/TD]
[TD="align: right"]10</SPAN>
[/TD]
[TD="align: right"]6</SPAN>
[/TD]
[TD="align: right"]6</SPAN>
[/TD]
[TD="align: right"]18</SPAN>
[/TD]
[TD="align: right"]20</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
 
Upvote 0
Is there a particular reason why they need to be out of order in Table 1?

If so, I just create a column between the name of the food and January and list that with an identifying code such as V, F or N. This would allow you to add new foods as you see fit and use that column as the identifier in your SUMIF statement.

You can see the code I used in the image
FoodTrackerExample_zps5639bbd9.jpg
 
Upvote 0
Thank you very much Weazel. I modified your formula, added word "Total" below the last nut in the column A and here is the formula working for me, I just add it to the table2 in the first cell and drag it to the right and downwards and it works perfectly.

=SUMPRODUCT(SUMIF(INDIRECT("$c$"&MATCH(C$1,C:C,0)+1&":$c$"&MATCH(C$17,C:C,0)-1),INDIRECT("$A"&MATCH($C21,$A:$A,0)+1&":$A"&MATCH(IF($C22=0,"*"&"Total"&"*",$C22),$A:$A,0)-1),INDIRECT(CHAR(64+MATCH(D$20,$1:$1,0))&"$"&MATCH(C$1,C:C,0)+1&":"&CHAR(64+MATCH(D$20,$1:$1,0))&"$"&MATCH(C$17,C:C,0)-1)))

[TABLE="class: grid, width: 712"]
<tbody>[TR]
[TD]vegetable[/TD]
[TD][/TD]
[TD]table1[/TD]
[TD]January[/TD]
[TD]February[/TD]
[TD]March[/TD]
[TD]April[/TD]
[TD]June[/TD]
[TD]July[/TD]
[TD]August[/TD]
[TD]September[/TD]
[/TR]
[TR]
[TD]carrot[/TD]
[TD][/TD]
[TD]peanut[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]radish[/TD]
[TD][/TD]
[TD]apple[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD]turnip[/TD]
[TD][/TD]
[TD]banana[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]7[/TD]
[/TR]
[TR]
[TD]cucumber[/TD]
[TD][/TD]
[TD]carrot[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD]cabbage[/TD]
[TD][/TD]
[TD]radish[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]fruits[/TD]
[TD][/TD]
[TD]grape[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD][/TD]
[TD]hazelnut[/TD]
[TD][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD]pear[/TD]
[TD][/TD]
[TD]pear[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]8[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]9[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD]banana[/TD]
[TD][/TD]
[TD]raspberry[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]grape[/TD]
[TD][/TD]
[TD]walnut[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]raspberry[/TD]
[TD][/TD]
[TD]cucumber[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]nuts[/TD]
[TD][/TD]
[TD]cabbage[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD]hazelnut[/TD]
[TD][/TD]
[TD]turnip[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD]walnut[/TD]
[TD][/TD]
[TD]coconut[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD]peanut[/TD]
[TD][/TD]
[TD]pine nut[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]coconut[/TD]
[TD][/TD]
[TD]total[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]52[/TD]
[TD="align: center"]47[/TD]
[TD="align: center"]45[/TD]
[TD="align: center"]52[/TD]
[TD="align: center"]58[/TD]
[TD="align: center"]52[/TD]
[/TR]
[TR]
[TD]pine nut[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]table2[/TD]
[TD]January[/TD]
[TD]February[/TD]
[TD]March[/TD]
[TD]April[/TD]
[TD]June[/TD]
[TD]July[/TD]
[TD]August[/TD]
[TD]September[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]vegetable[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]fruits[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]nuts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Match with multiple columns
2
Replies
14
Views
744
Peter_SSs
Peter_SSs
M
  • Solved
SumIf or equivalent
Replies
2
Views
172
Fluff
Fluff
F
  • Solved
SUMIF and AVERAGEIF two separate columns, only picking the greater value between the two column.
Replies
5
Views
282
hagia_sofia
hagia_sofia
T
  • Solved
Years visible only if there's a value in cell
Replies
6
Views
105
tigerzen
T
SanjayGMusafir
  • Solved
Filtering Dates within the dates and adding corresponding values
Replies
4
Views
320
SanjayGMusafir
SanjayGMusafir

Forum statistics

Threads
1,223,244
Messages
6,170,976
Members
452,372
Latest member
Natalie18

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