Formula for counting the amount of data cells with multiple criteria

I have a pivot table in which id-number is in key position. I need the right formula for getting out the # of transactions (differ from 0) for each particular id in a single cell. Each row presents a single transaction and there may be multiple transactions for the same id during each year. The sample is pretty small and therefore number of cases is slightly reduced, but I hope you get it. Having been trying it for several hours now with getting error messages for the formula, your help would be highly appreciated.

Small sample file attached describing the problem, please take a look.

So far the closest I've had is by the following formula:
=IF(COUNTIF(A$2:A2;A2)=1;COUNTIF(Table1[[2008]:[2016]];">0");"")
which gives me the amount of all transactions regardless the ID. (I have been using word in finnish, so some of the punctuation marks may vary.)
So from here I need the categorized amount for each particular ID.

Hi, just replied my best-so-far formula, does it bring any light on what I'm looking for? Sorry for my bad english. :P

Hi,
each row counts as one transaction, sorry for being unclear. In the formula I attached in previous post you may be needed to change the semi-colons with commas to get it work in english excel.

Thanks for your effort.
Here is a new attachment, hopefully it brings some light what I'm trying to get. As mentioned earlier, just counting the amount of each ID is not appropriate here because of the bigger data sheet I'm working with.
Just ask if I'm still too difficult to understand.
BR, jt93

Originally Posted by mcmahobt

The first part of your question seems straightforward then. In L2 (or K2), enter:

=IF(COUNTIF($A$2:A2,A2)=1,COUNTIF([id-number],A2),"")

The second part is much more complicated based on how you have your table set up. I'll have to think on it, unless FDibbins can jump in.

Thanks for your solution!
It was not still quite what I was looking for; as I mentioned before,

Also, only by counting how many times the ID appear is not admissable here, because in the "real pivot" I have there are also rows that does not have transactions. That's why I need the amount counted throughout the years.

Therefore my sample file was not perfect in describing the situation. The actual table consists over 1k rows, so going through it manually would take ages. Hopefully there is a solution for both my inquiries.

Originally Posted by mcmahobt

What are you "going through manually" regarding the formula I proposed? If you enter the formula, you can drag it down and have Excel autopopulate the cells.

I also forged a solution to your second question, but it is by no means elegant. Hopefully someone else can chime in to clean it up, but in any case it is referenced below. I also attached the example workbook you provided that I am working out of.

=IF(COUNTIFS(A$2:A2,A2)=1,IFERROR(SUMPRODUCT(--(([id-number]=A2)*([2008]>0)))/SUMPRODUCT(--(([id-number]=A2)*([2008]>0))),0)+IFERROR(SUMPRODUCT(--(([id-number]=A2)*([2009]>0)))/SUMPRODUCT(--(([id-number]=A2)*([2009]>0))),0)+IFERROR(SUMPRODUCT(--(([id-number]=A2)*([2010]>0)))/SUMPRODUCT(--(([id-number]=A2)*([2010]>0))),0)+IFERROR(SUMPRODUCT(--(([id-number]=A2)*([2011]>0)))/SUMPRODUCT(--(([id-number]=A2)*([2011]>0))),0)+IFERROR(SUMPRODUCT(--(([id-number]=A2)*([2012]>0)))/SUMPRODUCT(--(([id-number]=A2)*([2012]>0))),0)+IFERROR(SUMPRODUCT(--(([id-number]=A2)*([2013]>0)))/SUMPRODUCT(--(([id-number]=A2)*([2013]>0))),0)+IFERROR(SUMPRODUCT(--(([id-number]=A2)*([2014]>0)))/SUMPRODUCT(--(([id-number]=A2)*([2014]>0))),0)+IFERROR(SUMPRODUCT(--(([id-number]=A2)*([2015]>0)))/SUMPRODUCT(--(([id-number]=A2)*([2015]>0))),0)+IFERROR(SUMPRODUCT(--(([id-number]=A2)*([2016]>0)))/SUMPRODUCT(--(([id-number]=A2)*([2016]>0))),0),"")

Referring to your question, using the formula you provided me I would have to manually check the rows in which all the values are 0, so there is not a transaction at all. (This was the Achilles heel in my sample, there was no such an example row in it.) This formula anyways will save me a lot of time, thanks for helping!
Have to try out that monster formula, thanks for processing it out! I will tell whether it helps or not.