Re: Funkce v Excelu

From: Archemoros (archemoros@seznam.cz)
Date: 18. 05. 2002, 09:38 CEST

Previous message: spider_007: "Re: Funkce v Excelu"
In reply to: spider_007: "Re: Funkce v Excelu"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

> zkus toto =COUNTIF(C2:C31;">7.4 and <8.1")

Jo, tuhle a podobne kombinace jsem zkousel jako prvni, a vsechny bez
vysledku. Po utrapach jsem nakonec nasel reseni:

=COUNTIF(C2:C31;">=7.5")-COUNTIF(C2:C31;">8.0")

Ted se mi to samozrejme zda jasne a jednoduche, ale predtim me to nenapadlo.
Kazdopadne ale diky za snahu!

Archemoros

Previous message: spider_007: "Re: Funkce v Excelu"
In reply to: spider_007: "Re: Funkce v Excelu"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.2 : 18. 05. 2002, 09:38 CEST