Need formula to get the the specific value for each month

[amitmodi_mrt]

My data has months n col A and from col B till Col K it has some number, I want to know how many time 0 has appeared for specific month (in col p2/p3/p4). Please note months can be repeated multiple times.
Attached is the sample file.

[Pepe Le Mokko]

Please add your XL version to your profile. Thx

[amitmodi_mrt]

it is office 2013, updated the profile also..

[Pepe Le Mokko]

In Q2 and pull down

Please Login or Register  to view this content.

[wk9128]

P2 cell formula

[Pepe Le Mokko]

P2 cell formula

Just be aware OFFSET is a volatile function..

[wk9128]

Thank you for reminding, now that you have proposed a solution, provide another kind of thinking petition #01 reference

P2 Cell formula

[CARACALLA]

wrong formula

[wk9128]

The formulas #4, #5, and #7 Floor have been written in the attachment

Please download and refer to this attachment before coming back to discuss this issue