Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 29 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 32 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::load() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 161 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 138 Strict Standards: Non-static method JRequest::clean() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 33 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 463 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 464 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 465 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 466 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 467 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 468 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 35 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 38 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 39 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::load() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 161 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 138 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 46 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 47 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 50 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 53 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 54 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 57 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 58 Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 423 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 423 Warning: Cannot modify header information - headers already sent by (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 426 Som maken van namen, plaatsnamen, ...
Notice: Use of undefined constant add_css - assumed 'add_css' in /customers/2/1/8/versin.be/httpd.www/plugins/content/sexybookmarks.php on line 49 Notice: Undefined variable: add_class in /customers/2/1/8/versin.be/httpd.www/plugins/content/sexybookmarks.php on line 234

Som maken van namen, plaatsnamen, ...


Wat als je in een excellijst totalen wil maken die niet uit cijfers bestaan? Het optellen van getallen is zeer eenvoudig, maar ook het optellen van plaatsnamen, voor- en/of achternamen, adressen,...

Dan gebruik je gewoon de AANTAL.ALS formule

 

In het volgende voorbeeld staan vooral namen, als je in uitgebreide lijsten wil weten hoeveel maal Dendermonde, Versin,... of een andere naam voorkomt gebruik je de formule:

AANTAL.ALS(BEREIK;WAARDE)

Bereik is de startcel en eindcel van een kolom, gescheiden door een dubbelpunt bv C1:C6

Cirterium is de celwaarde waarvan je de som maakt (bv Versin of cel C4)

 

Het bereik in dit voorbeeld is de kolom plaats (c2 tot c7) en het criterium Dendermonde (c4) je ziet het totaal (2) onmiddellijk in het formule venster (functieargumenten)

Je kan in de formule ook het * gebruiken bv =AANTAL.ALS(C2:C7;"*endermonde") bv. indien er iemand Tendermonde consequent gebruikte...

 

 

Bureaublad achtergrond afbeeldingen

Laatste

Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109

Topbedrijven

Vochtbestrijdingsbedrijf Tibas bvba

Meest bezocht

Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79