K
kaushik
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 colum
A lets say "XYZ" or "PQR". For all instances of XYZ I need to comput
the total of all the numeric values for XYZ in column B and also th
total of all currencies correxponding to XYZ. The results should be i
two different cells. If Column A is null, equate 0 to both cells( tota
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 d
it
and Column D data is currency. I need to lookup for a string in colum
A lets say "XYZ" or "PQR". For all instances of XYZ I need to comput
the total of all the numeric values for XYZ in column B and also th
total of all currencies correxponding to XYZ. The results should be i
two different cells. If Column A is null, equate 0 to both cells( tota
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 d
it