On Thu, Apr 23, 2009 at 12:09 PM, Sergio Abadesso <
groups.abade...@googlemail.com> wrote:
> Hi gabo,
>
> it is possible to let look like the data of the upper example like yours
> below.
>
> Take a look in the Excel help by searching for "Pivot Table"
>
> Regards,
>
> Sergio
>
> 2009/4/23 gabo
>
use the sum product formula:
the derived formula is
=SUMPRODUCT(($D$2:$D$6)*($A$2:$A$6=$A13)*($C$2:$C$6=C$12)).
Pls check the attached excel sheet that I have prepared, for your help.
On Thu, Apr 23, 2009 at 1:37 AM, gabo wrote:
>
> I have a spreadsheet where I need to combine some rows into c
Hi gabo,
it is possible to let look like the data of the upper example like yours
below.
Take a look in the Excel help by searching for "Pivot Table"
Regards,
Sergio
2009/4/23 gabo
>
> I have a spreadsheet where I need to combine some rows into columns.
> Listed below is an example of the sp
