Multiple if functions with sum

L

louisa

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.
 
M

Mike H

Louisa,

Sumproduct may be a better option

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
Multiple IF Statement in Word 5
Sum of values in column A based on 0/1 of column B 2
Calculate the median value before a specified list 0
Multiple logic functions with multiple sums 2
Use TODAY() function as the criteria in a SUMIF formula 1
VLOOKUP or SUMIF for Multiple Criteria 2
Sum data using sumif 3

Top