Hello Board Users,
I am trying to SUM everything that is the same letter and under a certain column count. The formula i am using seems to work when the "columns" are in asending order, but I would like to modify it to only Sum the columns below a certain count.
Here is the Formula i am currently using:
The Table below starts in "A1". The SUM field is what I would like the out come to be.
For example, letter "a" should SUM every row from the input table that is "a" and less than the 3rd column of the table. Right now, it SUMS everything that is "a" row that is less than the Num.
Is this possilbe? Or will i have to adjust my table?
Thanks in advance. Really appreciate anybody's help.
alexb523
I am trying to SUM everything that is the same letter and under a certain column count. The formula i am using seems to work when the "columns" are in asending order, but I would like to modify it to only Sum the columns below a certain count.
Here is the Formula i am currently using:
Code:
=SUMPRODUCT($B$2:$G$9*($A$2:$A$9=$A12)*($B$1:$G$1<=$B12))
The Table below starts in "A1". The SUM field is what I would like the out come to be.
For example, letter "a" should SUM every row from the input table that is "a" and less than the 3rd column of the table. Right now, it SUMS everything that is "a" row that is less than the Num.
Is this possilbe? Or will i have to adjust my table?
Thanks in advance. Really appreciate anybody's help.
alexb523