EXCEL FUNCTION

Question

Hello. I would like to ask what function we use to add cells that have something in common between them. for example what function will we use to find the sum for the tomato cells in the example below A B 1 tomato 43 2 apple 25 3 tomato 67 4 orange 33 5 tomato 81

Answer 1

Hi,

sql:

select * from Sheet1;

select f01,sum(f02) from Sheet1 group by f01;

Answer 2

Hi,

You may create a Pivot Table. Alternatively, you may use the Groupby() function. In cell D1, enter this formula

=GROUPBY(A1:A6,B1:B6,SUM,3)

Hope this helps.

Answer 3

Use SUMIF as demonstrated below.