Sum rows if two columns = specific criteria.
 

I would like to set up a formula that will allow me to sum a column if the
row meets two criteria.



A B C D
1 Apple WA Active 5
2 Pear OR Closed 6
3 Apple OR Active 2
4 cherry WA Closed 3
5 cherry ID Active 4
6 Peach ID Closed 7

example,
I would like the sum of Column D where colum B = Apple & column C = Wa
in this example that would be 5

I have been unable to figure this out using two variables.

--
Jeff

Sum rows if two columns = specific criteria.
 

=SUMPRODUCT(--(A1:A100="Apple),--(B1:B100="Wa"))

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Jeff" wrote in message
...
I would like to set up a formula that will allow me to sum a column if the
row meets two criteria.



A B C D
1 Apple WA Active 5
2 Pear OR Closed 6
3 Apple OR Active 2
4 cherry WA Closed 3
5 cherry ID Active 4
6 Peach ID Closed 7

example,
I would like the sum of Column D where colum B = Apple & column C = Wa
in this example that would be 5

I have been unable to figure this out using two variables.

--
Jeff

Sum rows if two columns = specific criteria.
 

Hi,

You may also try the following array formula (Ctrl+Shift+Enter):

=sum(if((rangeA="Apple")*(rangeB="WA"),rangeD))

Regards,

"Jeff" wrote:

I would like to set up a formula that will allow me to sum a column if the
row meets two criteria.



A B C D
1 Apple WA Active 5
2 Pear OR Closed 6
3 Apple OR Active 2
4 cherry WA Closed 3
5 cherry ID Active 4
6 Peach ID Closed 7

example,
I would like the sum of Column D where colum B = Apple & column C = Wa
in this example that would be 5

I have been unable to figure this out using two variables.

--
Jeff