Count values between two static

[sealpino]

Need to count the 1 and 2 for each article.
See attached xls.

[etaf]

you could do pivot table

or use a countifs()

[Glenn Kennedy]

You can use a COUNTIFS formula, like this:

=COUNTIFS($A:$A,$E2,$B:$B,F$1)

see shhet to see it in place.

[sealpino]

You can use a COUNTIFS formula, like this:

=COUNTIFS($A:$A,$E2,$B:$B,F$1)

see shhet to see it in place.

I am looking at this one, though I found out that I have a lot of empty fields. I do not want to count those. Only if the field is with text.
Can it be easily adjusted?

[JeteMc]

You can modify Glenn's formula to read:

Please Login or Register  to view this content.

If you are using a formula to get a unique list of articles you could use*:

Please Login or Register  to view this content.

*The preceding formula is an array entered formula, meaning that it is activated by simultaneously pressing the Ctrl, Shift and Enter keys while the cell is in edit mode.
I was unsure of whether you mean that there was no value in column A, B or both, however these two modifications help in all three instances (see attached copy of Glenn's file).
Let us know if you have any questions.