Using =COUNTIF to do a sequential count based on three matched columns.

Hi all,

I am having an issue with using a =COUNTIF() formula.

I have a table with a number on columns and i am trying use one of the columns to keep a sequential count if three of the columns have matched data in them.

It works OK as long as the third set of criteria is in the lower of the matched rows.

To help explain i have included an example workbook.

Here is the formula, =COUNTIFS($B$4:B4,B4,$C$4:C4,C4,$D$4:D4,"="&"D/T")

you have fixed the d/t so it will match on any line, perhaps to avoid this
=IF(D32="D/T",COUNTIFS($B$26:B32,B32,$C$26:C32,C32,$D$26:D32,"D/T"),0)

The formula is returning the correct answer. The question is what are you seeking to count exactly? What is the answer you expect to see in E32, and why ?
Maybe the formula needs to be adjusted accordingly..

Hi,

If the first two sets of criteria are a match and the third set of criteria = D/T than keep a count. 1,2,3,4 and so on. As i mentioned, it works but only if D/T appears in the lowest of the matched rows. See sample workbook.

i should also mention that the table will have new rows of data added to it.

Thank you vary much.