N
Newsweek
Hi
I am quite a novice with MSExcel but have managed to achieve some success
with formulas and formatting even between worksheets.
However I am struggling with the following problem and would appreciate some
advice.
I have two columns, each of thirty cells, Column J will contain either the
letter C or the letter P and column K will contain an amount.
I want cell D37 to contain the total of only the cells in column K where the
corresponding cells in column J equals "P" and likewise
I want cell D38 to contain the total of only the cells in column K where the
corresponding cells in column J equals "C".
Hope I have explained this ok.
Many thanks, Rob
I am quite a novice with MSExcel but have managed to achieve some success
with formulas and formatting even between worksheets.
However I am struggling with the following problem and would appreciate some
advice.
I have two columns, each of thirty cells, Column J will contain either the
letter C or the letter P and column K will contain an amount.
I want cell D37 to contain the total of only the cells in column K where the
corresponding cells in column J equals "P" and likewise
I want cell D38 to contain the total of only the cells in column K where the
corresponding cells in column J equals "C".
Hope I have explained this ok.
Many thanks, Rob