Need to Total the number of entries in a column that are >15

[AWESiF]

Hello! I have an Excel sheet that counts the number of different cell categories on blood films (lymphocytes, neutrophils, smudge cells, etc). I'm trying to total the number of films where a specific category of cell was reported >15 times. Eg. the number of films where >15 lymphocytes were counted.

The categories are columns and the film IDs are rows...

Can anyone help me out? Thanks!

[#2 · Accepted solution]

Hello @AWESiF,

This would be possible with the COUNTIF() function. For example:

=COUNTIF(lymphocytes_Column,">15")

[#3]

I would need to see a sample data set to help accurately.

[#4]

That worked beautifully. Thank you!
I will definitely do an EXCEL training course of some kind as soon as I have the time, lol.
Until then, this forum is amazing.

[#5]

@AWESiF 

You're welcome!