# Revision history [back]

Why not?

=SUMIFS(C:C;A:A;"foo";B:B;"bar")


or

=SUMPRODUCT(C:C;A:A="foo";B:B="bar")


It's more like "select SUM(C)...". But you said in the question that for the result you select one cell E1.