An Array formula might be the answer. Have you got an example of the dataset
please?

John


"will" wrote:

Hi,

Is there a way of listing those items that have a certain criteria - in
other words a sort of "ListIf" type command? Just as SumIf would sum the
values of items that have a certain criteria?

Many thanks for any assistance.

Mark.