COUNTIFS Formula Assistance

Hi folks

I have this formula:

=COUNTIFS(E:E,"A",J:J,0,C:C,1)

For the next couple of hundred cells down the formula would be the same but with C:C,2 etc

Is there a formula that can be used to just drag down rather than having to do each one individually?

Thanks
Hammer

i agree dear but C:c is have certain value upto which you have to calculate for e.g >100 or < 100 etc use (c:c, ">=" & 2) like wise or attach sheet where you want your result with example

Thanks folks I will attach a sample sheet shortly.

Worksheet attached

Hi,

I have provided a formula but i am not sure whether it will work for u or not

The logic is still confusing, it wold be easy if u take typical example & explain in detail by showing before & after sheet.

Punnam

Hi Punnam
I've cracked it with your assistance
tytyty

Hammer2
Welcome .

Punnam