Sum Arrays

  • Thread starter Thread starter Graham Parkinson
  • Start date Start date
G

Graham Parkinson

I have the following table of values


Unique IDs 1 1_1 1_2 2 3 4_1
A 1F 2H
B 1L 2F 3F 4H
C 1H
D 1H 2F
E
etc

I want to count how many 1Fs across all unique IDs there
are where the top row starts with a one (in this case
there would just be one for unique ID A). Then counting
1Fs with top row beginning with 2, etc. I will then count
how many 2Fs there are with the top row starting with a
one (2 in this case).

I've tried a sum array but I just get zeros for the
results.

Thanks

Graham
 
Hi Graham,

Try this:

=SUMPRODUCT((B3:G6="1F")*(B2:G2=B2))

Where B2 holds the value 1. Adjust ranges as needed.

Biff
 
Back
Top