N
Need help with sumif
Date Sold Item Price
11/6/2008 Apple $3
11/6/2008 Orange $15
11/7/2008 Orange $2
11/7/2008 Apple $20
11/8/2008 Banana $5
11/8/2008 Orange $500
How do I lookup only Apple and return the sum on Price column
Assume Date Sold is A column Item is B Column Price is C Column
11/6/2008 Apple $3
11/6/2008 Orange $15
11/7/2008 Orange $2
11/7/2008 Apple $20
11/8/2008 Banana $5
11/8/2008 Orange $500
How do I lookup only Apple and return the sum on Price column
Assume Date Sold is A column Item is B Column Price is C Column