The formula 'box' is quite clear. There is a range of data, ONE criteria box
and a range to be summed. All quite clear but there doesn't seem to be the
option to add criteria in order to say SUMIF Citeria 1 = X nd criteria 2 = Y.
Is there a way of me manually inputting this second criteria?
I can do the sumif formula easily enough with the three sections being
separated by a comma but have no idea how to add this second criteria.

=SUMPRODUCT(--(rng1="x"),--(rng2="y"),rng3)


"Count1314" wrote:

The formula 'box' is quite clear. There is a range of data, ONE criteria box
and a range to be summed. All quite clear but there doesn't seem to be the
option to add criteria in order to say SUMIF Citeria 1 = X nd criteria 2 = Y.
Is there a way of me manually inputting this second criteria?
I can do the sumif formula easily enough with the three sections being
separated by a comma but have no idea how to add this second criteria.