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