Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing formula
Can someone help me please?
I know pivots tables will provide this information but they are to memory intensive. I want to be able sum the figures in a column if another column meets a text value in that same row. Orange, 2 Lemon, 4 Apple, 7 Peach, 3 Orange, 5 So I get a SUM result for Oranges as 7 Thanks -- Mark |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing formula
Hi Mark,
Try using =SUMIF The syntax is =SUMIF(Range to find the criteria, the criteria, range to find the quantity) In your case this might be =SUMIF(A1:A4,"Orange",B1:B4) Note the quotes arange the criteria Hope this helps, regards Phil Mark wrote: Can someone help me please? I know pivots tables will provide this information but they are to memory intensive. I want to be able sum the figures in a column if another column meets a text value in that same row. Orange, 2 Lemon, 4 Apple, 7 Peach, 3 Orange, 5 So I get a SUM result for Oranges as 7 Thanks -- Mark |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing formula
Many thanks
-- Mark "Phil" wrote: Hi Mark, Try using =SUMIF The syntax is =SUMIF(Range to find the criteria, the criteria, range to find the quantity) In your case this might be =SUMIF(A1:A4,"Orange",B1:B4) Note the quotes arange the criteria Hope this helps, regards Phil Mark wrote: Can someone help me please? I know pivots tables will provide this information but they are to memory intensive. I want to be able sum the figures in a column if another column meets a text value in that same row. Orange, 2 Lemon, 4 Apple, 7 Peach, 3 Orange, 5 So I get a SUM result for Oranges as 7 Thanks -- Mark |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing formula
Mark,
In column A, starting with A4: Orange, Lemon, Apple, Peach, Orange In column B, starting with B4: 2, 4, 7, 3, 5 In column C, starting with C4: "=Vlookup(A5,A4:B9,2,True)" without "" This will total 7 Oranges in the first cell. HTH "Mark" wrote: Can someone help me please? I know pivots tables will provide this information but they are to memory intensive. I want to be able sum the figures in a column if another column meets a text value in that same row. Orange, 2 Lemon, 4 Apple, 7 Peach, 3 Orange, 5 So I get a SUM result for Oranges as 7 Thanks -- Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Summing a column with formula value... | Excel Worksheet Functions | |||
What formula will eliminate the cell with #N/A when summing? | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
summing formula | New Users to Excel |