Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.