Hi,

If I understand correctly the following formula will do it:

=SUMPRODUCT((D2:D350=G2)*(LEFT(F2:F350)="A"))

Where cell G2 contains the account numbers.

The second part of the question seems to be asking something different: "I
then need to count how ... don't have a reference allocated" If you are
trying to find how may blank cells there are in column D you would use
=COUNTBLANK(D2:D350)

--
Thanks,
Shane Devenshire


"Twishlist" wrote:

I would greatley appreciate assistance with how to count the following:
If range d2:d350 contains varied account numbers, and range f2:f350 contain
a variety of system types (all starting with A), how do I total the number of
systems (all 'A' varieties) that belong to each account. I guess counting
the number of unblank cells in f2:f350 would do it, but can't work out the
correct formula.
I then need to count how many of the range D do not have a reference
allocated.