Hi Arvi

I agree the OP wants to see the results in individual columns, but the
source data is in a single column.
Your formula
=SUBTOTAL(3,INDEX(MyTable,,COLUMN()))

will give a Count (not a Sum)<bg
but the column returned when the formula is in cell E1 will be 5 and
since Mytable is set to A:G it will perform the calculation on column E
which has no data.
When copied to F1 will be 6 etc.

The values to be Summed, are all in column C

--
Regards

Roger Govier


"Arvi Laanemets" wrote in message
...
Hi


"Roger Govier" wrote in message
...
Hi Arvi

I don't think that works, as the type for each fruit are all held in
the one column.

E1:G1 - Fuits (Apples, Oranges, Lemons)

It looks like I was right and you wrong at it :-)))

E2:G2 - Need a function to show the quantities of fruits when I
select
each client with the AutoFilter.

Here I moved the placement of formulas at top of page

In other words, if I select client "A" with the AutoFilter, in cell
E2 I want the quantity of Apples.

... and in cell F2 the quantity of oranges etc. ...


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )