Sumif two criteria in different row/column

[newbieTin]

month Date description amount
1 1/20/13 apple 16
1 1/28/13 grapes 20
2 2/1/13 apple 5

I want to add all the apple in the same month. I’m making the summary below. In excel it is usually sumifs() but it seems that Calc doesn’t allow it. Can anybody help me?

SUMMARY
JAN FEB
apple 16 5
grapes 20

[JohnSUN]

But you don’t want to try to choose Data - Pivot Table - Create?

[mariosv]

You can take a look to this threads:

Sumifs alternative

I knew that LibreOffice not yet support the Excel ‘*IFS’ (sumifs, averageifs, countifs, etc) functions. Is there any alternative formula for conditional sum with more than one criteria?

SUMIF with Functions?

Hi, I’m not sure this is even possible, but I’m hoping someone can show me how if it is (and that it is). The best way I can think to describe this is to make a little diagram, so I hope this is readable. A B C 1 5 1 A 2 7 3 B 3 2 2 A 4 9 4 C Ok, what I want to do is make 1 cell (let’s say D5, just for kicks) give me the sum of column A where column C is “A” (so 7, 5 from row 1 and 2 from row 3) and the max of column B where column C is “A” (so 2, for row 3, since row 3’s 2 is…

But please take in consideration the JohnSUN proposal about using Pivot Table, It is design for those tasks.