Count and tick down the number of occurrence with multiple criteria.

[aggie81]

I used to use countif($a$2:a2,a2) to count and then number each occurrence of a number in a column but now need some help to get if done with multiple criteria.

DESCRIPTION
4" BEGONIA-BADA BING SCARLET 1
4" BEGONIA-BADA BING SCARLET 2
4" BEGONIA-BADA BING SCARLET 3
4" BEGONIA-BADA BING SCARLET 4
4" BEGONIA-BADA BING SCARLET 5
4" BEGONIA-BADA BING SCARLET 6
4" BEGONIA-BADA BING SCARLET 7
4" BEGONIA-BADA BING SCARLET 8
4" BEGONIA-BADA BING SCARLET 9
4" BEGONIA-BADA BING SCARLET 10

I used the formula below to get the results above but when I add other criteria it doesn't work.
=COUNTIFS(INDEX([Item Number],1):[@[Item Number]],[@[Item Number]])

 

[aggie81]

I used to use countif($a$2:a2,a2) to count and then number each occurrence of a number in a column but now need some help to get if done with multiple criteria.

DESCRIPTION
4" BEGONIA-BADA BING SCARLET 1
4" BEGONIA-BADA BING SCARLET 2
4" BEGONIA-BADA BING SCARLET 3
4" BEGONIA-BADA BING SCARLET 4
4" BEGONIA-BADA BING SCARLET 5
4" BEGONIA-BADA BING SCARLET 6
4" BEGONIA-BADA BING SCARLET 7
4" BEGONIA-BADA BING SCARLET 8
4" BEGONIA-BADA BING SCARLET 9
4" BEGONIA-BADA BING SCARLET 10

I used the formula below to get the results above but when I add other criteria it doesn't work.
=COUNTIFS(INDEX([Item Number],1):[@[Item Number]],[@[Item Number]])

Sorry posted before I said thanks for your help and looking.

 

[Asheesh]

hi - Can you please share the sample file..

 

[aggie81]

Thanks I figured it out. I have to use the same index() formula for each criteria range inside the countifs() formula so that it pins it to the first cell in the range when using a table and that all the criteria ranges are the same.
I should have realized that but forgot and still not used to the syntax changes when doing stuff inside tables.
Thanks,
Lee