Nije jasno zašto za uslove navodiš konkretne vrednosti a u formuli koristiš reference!?
Promeni formulu tako da odgovara uslovima:
Code:
=SUMPRODUCT((D1:D165) * (A1:A165 = "K-800") * (B1:B165 = "L") * (C1:C165 = -1))
ili je piši sa apsolutnim referencama:
Code:
=SUMPRODUCT((D1:D165) * (A1:A165 = $A$184) * (B1:B165 = $C$183) * (C1:C165 = $B$184))
Uostalom, postavi fajl sa primerom koji opisuješ.
Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!