Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I lookup only Apple and return value on Price Column and su
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I lookup only Apple and return value on Price Column and su
in say, D1: =SUMIF(B:B,"Apple",C:C)
-- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "Need help with sumif" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I lookup only Apple and return value on Price Column and su
And if you're looking at multi-criteria summing, beyond SUMIF,
then something like this: =SUMPRODUCT((TEXT(A2:A10,"mmmyy")="Nov08")*(B2:B10 ="Apple"),C2:C10) which will yield the total of col C's figs for Apples in col B where dates in col A are Nov 08. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help, How do I create apple to apple and apple to orange charts | Charts and Charting in Excel | |||
Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
Lookup a row and column and return value | Excel Worksheet Functions | |||
lookup from one column return value from another? | Excel Discussion (Misc queries) |