Counting Cells in a row depending on value in columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following tabl

L L L Q Q L
Play 1 2 2 1 1 1
Play 2 2 1 1
Play 3 1 0 0 1

Now for each Play I need to count all numbers where the column header is "L" the result for Play 1 is: 4, for play 2 it is 3, and for Play 3 it is 3. Any idea on what formula will yield this result.
 
try using the count if formula use the help for basic
knowledge and then google for countif formula there's a
lot of stuff out there, p.s. i have just used some as i am
a beginner at count if but here is an example of what you
will need!

=COUNTIF(A1:A5,"L")

which should work
 
Thank you Jt - but the formula does not work, allready tried it and variations of it, because it doesn't seem to be able to count in one row depending og a corresponding value pr column in another row.
 
Try

=SUMPRODUCT((ISNUMBER(B2:H2))*(B$1:H$1="L"))

Assuming headings (Ls and Qs start at B1.

sphenisc


Eagle2 said:
Thank you Jt - but the formula does not work, allready tried it and
Click to expand...
variations of it, because it doesn't seem to be able to count in one row
depending og a corresponding value pr column in another row.
 
Back
Top