Citat:
component: Kada pogledaš polje trebalo bi da izgleda ovako:
{=COUNT(IF(B2:B6>300;IF(C2:C6>300)))}
Prvo, ova formula nije dobro napisana: f-ja IF() ima 3 argumenta - kod tebe samo 2 i 1..
Drugo, doslovno preneseni zadatak iz tabele glasi:
Koliko je zemalja ucestvovalo
u razmeni tokom 2001 I 2002 g., a da je njihovo ucesce u milionima USD bio manji od 300.
Dakle, treba brojati vrednosti koje su
manje (a ne veće) od 300:
Code:
{=SUM(IF(B2:B6<300; IF(C2:C6<300; 1; 0); 0))}
isto to, samo sa SUMPRODUCT():
Code:
=SUMPRODUCT(--(B2:B6<300); --(C2:C6<300))
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!