if function

[adriana25]

Hi! can someone help me? I have the cells
A1 Thiery A2 thiery
B1 blouse B2 blouse
C1 Black C2 red
D1 25 D2 30 etc

in a cell i have to do this formula: Sum the numbers of D1:D300 only If in the cells A1:A300 you will find "thiery", and B1:B300 you will find "blouse" and in the cells C1:C300 you will find "black"

Is that possible?

thanks

 

[jeffreybrown]

If you have 2007

=SUMIFS($D$1:$D$300,$A$1:$A$300,"thiery",$B$1:$B$300,"blouse",$C$1:$C$300,"black")

Earlier version

=SUMPRODUCT(--($A$1:$A$300="thiery"),--($B$1:$B$300="blouse"),--($C$1:$C$300="black"),$D$1:$D$300)

 

[adriana25]

greeat

it is worked

thank you sooo much

 

[jeffreybrown]

You're welcome and glad it worked for you