On 2012-09-06 13:59, Johnny Rosenberg wrote:
I have a spreadsheet with quite a lot of values and text.
Column C: Name.
Column D: Date.
Column H: Values (integers, currently in the range of 176 to 605).
R1: A specific name that matches many of the rows of column C.
P2: Start date.
Q2: End date.
Johnny Rosenberg wrote:
I have a spreadsheet with quite a lot of values and text.
Column C: Name.
Column D: Date.
Column H: Values (integers, currently in the range of 176 to 605).
R1: A specific name that matches many of the rows of column C.
P2: Start date.
Q2: End date.
I tried this:
{=SUM((
I have a spreadsheet with quite a lot of values and text.
Column C: Name.
Column D: Date.
Column H: Values (integers, currently in the range of 176 to 605).
R1: A specific name that matches many of the rows of column C.
P2: Start date.
Q2: End date.
I tried this:
{=SUM(($C$2:$C$1001=R$1)*($D$2:$D