Counting formula
in [Functions]
|
From: lawhawg on 19 Mar 2010 22:41 I need a formula to sum on the cells that match a variable in another cell A B C D E F G H I 1 2 Bo Jim Ron 3 3 2 6 4 1 2 3 4 5 6 ? ? ? What I need to be able to do is sum the number of columns (A4:F4) that matches the numbers in G3:I3. So, the sum I'm looking for in G4 is 6 (the sum of A4:C4) or 6. H4 would sum to 3 and I4 would be 21. Can you help me please?
From: T. Valko on 19 Mar 2010 23:15 Try this... =SUM($A4:INDEX($A4:$F4,G3)) Copy across. Note that if G3 is an empty cell the formula will sum the *entire* range. -- Biff Microsoft Excel MVP "lawhawg" <lawhawg(a)discussions.microsoft.com> wrote in message news:54D84B19-949D-4E39-B025-5EFAFB6CE1C0(a)microsoft.com... >I need a formula to sum on the cells that match a variable in another cell > > A B C D E F G H I > 1 > 2 Bo Jim Ron > 3 3 2 6 > 4 1 2 3 4 5 6 ? ? ? > > What I need to be able to do is sum the number of columns (A4:F4) that > matches the numbers in G3:I3. So, the sum I'm looking for in G4 is 6 > (the > sum of A4:C4) or 6. H4 would sum to 3 and I4 would be 21. Can you help > me > please?
|
Pages: 1 Prev: Moving Cell Formula Next: formula to a minimum value of zero if a negative number |