Frozen_Cloud
New Member
- Joined
- Oct 10, 2010
- Messages
- 57
- Reaction score
- 1
Witam,
moglby mi ktos pomoc w skroceniu tej formuly?
=COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G19")
moglby mi ktos pomoc w skroceniu tej formuly?
=COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129A19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129B19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129C19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129D19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129E19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129F19")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G10")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G11")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G12")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G13")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G14")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G15")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G16")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G17")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G18")+COUNTIF('[BINS NUMMERN.xlsx]Sheet1'!$A$1:$A$100;"P-1-E129G19")