Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Lookup
I have 3 columns. Column A data is all text, Column B data is numeric, and Column D data is currency. I need to lookup for a string in column A lets say "XYZ" or "PQR". For all instances of XYZ I need to compute the total of all the numeric values for XYZ in column B and also the total of all currencies correxponding to XYZ. The results should be in two different cells. If Column A is null, equate 0 to both cells( total of all numerics values and total of currency values). Thanks you all in advance for your help. PS: If I have to reference the columns in a different sheet how do I do it. -- kaushik ------------------------------------------------------------------------ kaushik's Profile: http://www.excelforum.com/member.php...o&userid=34715 View this thread: http://www.excelforum.com/showthread...hreadid=547984 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Lookup
See the SUMIF function.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "kaushik" wrote in message ... I have 3 columns. Column A data is all text, Column B data is numeric, and Column D data is currency. I need to lookup for a string in column A lets say "XYZ" or "PQR". For all instances of XYZ I need to compute the total of all the numeric values for XYZ in column B and also the total of all currencies correxponding to XYZ. The results should be in two different cells. If Column A is null, equate 0 to both cells( total of all numerics values and total of currency values). Thanks you all in advance for your help. PS: If I have to reference the columns in a different sheet how do I do it. -- kaushik ------------------------------------------------------------------------ kaushik's Profile: http://www.excelforum.com/member.php...o&userid=34715 View this thread: http://www.excelforum.com/showthread...hreadid=547984 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |