I am looking to find a formula that will do what this pivot did.

Esentially the summarized pivot allows you to run a count formula at the end to sount all months, and then the count only returns the months with values. So the =Count for the highlighted columns on the pivot is 6.
pivot.PNG


But how do I write that type of formula to the data file so I can get rid of the pivot?

it would need to count all 12 moths in a year, but only 6 of them have values.

raw data.PNG