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 )