Sum Data with Column & Row Conditions

[mbshafe]

I have an array of data that looks something like this:

Type Bought Cost

Apples Today $2
Bananas Today $5
Grapes Last Week $3
Apples Yesterday $2.50
Oranges Today $1.50
Apples Last Week $4
Bananas Yesterday $3.50
Apples Today $3.25

I want to have an array that looks something like this:

Type Today Yesterday Last Week
Apples $5.25 $2.50 $4
Bananas $5 $3.50 0
Grapes 0 0 $3
Oranges $1.50 0 0

Could someone please suggest a formula for, say, "apples bought today"? TIA, Mike

 

[sxhall]

Try

{=SUM(IF(A1:A12="Apples",IF(B1:B12="Today",C1:C12,0),0))}

You will to pres ctrl, shift & return once typed to get the formula (an array formula) to work.

 

[mbshafe]

This worked great, thanks!!!