Hello,

I have rows of data where in row 1 there is a threshold value (problem
is that the threshold is different for all samples from A to for
example E). In row 2 I have a different value for each sample. I now
want to count all the samples in row 2 where the value in row 2 is
greater than the corresponding value in row 1.

I also want to do a sumif for that.

So my data is like this:

1A: 50 1B: 71 1C: 50 1D: 50 1E: 50
2A: 51 2B: 0 2C: 52 2D: 70 2E: 5

The count would give out 3 (counting 2A, 2C and 2D), the sum would
give out 173.

Any solution for my problem?