Re: [libreoffice-users] Calc: Average value, multiple conditions

2012-09-06 Thread TomW
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.

Re: [libreoffice-users] Calc: Average value, multiple conditions

2012-09-06 Thread Dan Lewis
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((

[libreoffice-users] Calc: Average value, multiple conditions

2012-09-06 Thread Johnny Rosenberg
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