Multiple if functions with sum

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

louisa - 04 Feb 2008 10:28 GMT

I need to embed if and sum functions. I know there is a way of doing this if
you have more than one condition. For example if you wanted to sum if column
A had a value of 1 and column b had a value of 2, then sum the column c
values.

I believe there is an add in but am not too sure how to get it.

Reply to this Message

Mike H - 04 Feb 2008 11:13 GMT

Louisa,

Sumproduct may be a better option

=SUMPRODUCT((A1:A1000=1)*(B1:B1000=2)*(C1:C1000))

Mike

> I need to embed if and sum functions. I know there is a way of doing this if
> you have more than one condition. For example if you wanted to sum if column
> A had a value of 1 and column b had a value of 2, then sum the column c
> values.
>
> I believe there is an add in but am not too sure how to get it.

Reply to this Message