{"id":7794,"date":"2024-03-28T14:00:53","date_gmt":"2024-03-28T14:00:53","guid":{"rendered":"https:\/\/tech-lib.eu\/tech\/?p=7794"},"modified":"2024-03-28T14:00:53","modified_gmt":"2024-03-28T14:00:53","slug":"jak-pouzivat-sumif-v-excelu-2013","status":"publish","type":"post","link":"https:\/\/tech-lib.eu\/tech\/jak-pouzivat-sumif-v-excelu-2013\/","title":{"rendered":"Jak pou\u017e\u00edvat SUMIF v Excelu 2013"},"content":{"rendered":"
\n
What is the difference between Sumif and Sumifs?<\/div>\n
Difference Between Excel SUMIF and Excel SUMIFS Functions Both are logical SUM functions that find the SUM of a given range based on specified conditions. The only difference between Excel SUMIFS & SUMIF functions is that SUMIFs can check for multiple criteria at once, while SUMIF can check for one criterion at a time.<\/div>\n
\n\t\t\t\t\t Dal\u0161\u00ed informace najdete na<\/span> www.simonsezit.com<\/a>\n\t\t\t\t<\/div>\n<\/p><\/div>\n
Excel je siln\u00fd n\u00e1stroj, kter\u00fd u\u017eivatel\u016fm umo\u017e\u0148uje prov\u00e1d\u011bt n\u011bkolik v\u00fdpo\u010dt\u016f a anal\u00fdz jejich dat. Funkce SUMIF v aplikaci Excel je jednou z nejvyu\u017e\u00edvan\u011bj\u0161\u00edch funkc\u00ed, proto\u017ee umo\u017e\u0148uje s\u010d\u00edtat data na z\u00e1klad\u011b ur\u010dit\u00fdch krit\u00e9ri\u00ed. Tento \u010dl\u00e1nek vysv\u011btl\u00ed, jak funkci SUMIF v aplikaci Excel 2013 vyu\u017e\u00edvat, a poskytne n\u011bkter\u00e9 souvisej\u00edc\u00ed informace. <\/p>\n
1. Jak\u00fd je vzorec aplikace Excel pro funkci SUMIF? <\/div>\n

Chcete-li pou\u017e\u00edvat funkci SUMIF aplikace Excel, mus\u00edte dodr\u017eovat p\u0159esnou syntaxi. Obecn\u00fd form\u00e1t funkce SUMIF je n\u00e1sleduj\u00edc\u00ed: Rozsah, krit\u00e9rium a [sum_rozsah] = SUMIF <\/p>\n

<\/div>\n

– Rozsah: To je rozsah bun\u011bk, kter\u00e9 chcete porovnat s po\u017eadavky. M\u016f\u017ee to b\u00fdt jeden \u0159\u00e1dek, jeden sloupec nebo oboj\u00ed. <\/p>\n

<\/div>\n

– Krit\u00e9rium: Jedn\u00e1 se o po\u017eadavek nebo normu, kterou chcete pou\u017e\u00edt k definov\u00e1n\u00ed rozsahu. M\u016f\u017ee to b\u00fdt odkaz na bu\u0148ku, text, \u010d\u00edslo nebo logick\u00fd v\u00fdraz. <\/p>\n

<\/div>\n

– Sum_range: Tento nepovinn\u00fd argument ur\u010duje rozsah bun\u011bk, kter\u00e9 chcete se\u010d\u00edst. Pokud nen\u00ed zad\u00e1n, Excel se\u010dte rozsah uveden\u00fd v prvn\u00edm argumentu. <\/p>\n

<\/div>\n

P\u0159ed zad\u00e1n\u00edm vzorce se spr\u00e1vnou syntax\u00ed pro pou\u017eit\u00ed funkce SUMIF mus\u00edte nejprve vybrat bu\u0148ku, ve kter\u00e9 se m\u00e1 v\u00fdsledek zobrazit. Nap\u0159\u00edklad pro se\u010dten\u00ed hodnot ve sloupci A na z\u00e1klad\u011b krit\u00e9ri\u00ed ve sloupci B byste vzorec zadali takto: B:B, „krit\u00e9ria“, A:A, =SUMIF(B:B, „krit\u00e9ria“) <\/p>\n

<\/div>\n

skute\u010dnou podm\u00ednku, kterou chcete pou\u017e\u00edt m\u00edsto „krit\u00e9ri\u00ed“ <\/p>\n

Jak lze funkci SUMIF pou\u017e\u00edt s textovou podm\u00ednkou? <\/div>\n

Textov\u00e1 krit\u00e9ria lze pou\u017e\u00edt tak\u00e9 s funkc\u00ed SUMIF. Aby bylo mo\u017en\u00e9 krit\u00e9rium pou\u017e\u00edt s textovou podm\u00ednkou, mus\u00ed b\u00fdt uzav\u0159eno do dvojit\u00fdch uvozovek. M\u016f\u017eete nap\u0159\u00edklad zadat n\u00e1sleduj\u00edc\u00ed vzorec, kter\u00fd se\u010dte hodnoty ve sloupci B za p\u0159edpokladu, \u017ee hodnota v odpov\u00eddaj\u00edc\u00ed bu\u0148ce ve sloupci A se rovn\u00e1 „Jablka“: A:A, „Jablka“, B:B, =SUMIF(A:A, „Jablka“) <\/p>\n

Pomoc\u00ed tohoto vzorce se se\u010dtou pouze ty hodnoty ve sloupci B, jejich\u017e odpov\u00eddaj\u00edc\u00ed bu\u0148ka ve sloupci A je ozna\u010dena jako „Jablka“. <\/div>\n

3. Jak m\u00e1m pou\u017e\u00edt spr\u00e1vnou syntaxi funkce SUMIF()? <\/p>\n

<\/div>\n

N\u00e1sleduje spr\u00e1vn\u00e1 syntaxe funkce SUMIF: Rozsah, Krit\u00e9ria a [sum_range] = SUMIF M\u011bjte na pam\u011bti, \u017ee argumenty rozsah a sum_range mohou b\u00fdt jednotliv\u00e9 bu\u0148ky, rozsahy bun\u011bk nebo oboj\u00ed. Krit\u00e9riem m\u016f\u017ee b\u00fdt odkaz na bu\u0148ku, text, cel\u00e9 \u010d\u00edslo nebo logick\u00fd v\u00fdraz. <\/p>\n

4. Jak se pou\u017e\u00edvaj\u00ed SUM a SUMIFS? <\/div>\n

Funkce SUMIFS umo\u017e\u0148uje s\u010d\u00edtat \u010d\u00edsla na z\u00e1klad\u011b r\u016fzn\u00fdch krit\u00e9ri\u00ed, na rozd\u00edl od funkce SUMIF, kter\u00e1 umo\u017e\u0148uje s\u010d\u00edtat hodnoty pouze na z\u00e1klad\u011b jedn\u00e9 podm\u00ednky. Funkce SUMIFS m\u00e1 podobnou syntaxi jako funkce SUMIF a umo\u017e\u0148uje zadat n\u011bkolik rozsah\u016f a krit\u00e9ri\u00ed. <\/p>\n

<\/div>\n
<\/div>\n

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2],…) je obvykl\u00fd form\u00e1t funkce SUMIFS. Lze pou\u017e\u00edt libovoln\u00fd po\u010det krit\u00e9ri\u00ed a rozsah\u016f krit\u00e9ri\u00ed. Funkce se\u010dte pouze hodnoty, kter\u00e9 spl\u0148uj\u00ed v\u0161echny po\u017eadavky. <\/p>\n

<\/div>\n

Z\u00e1v\u011brem lze \u0159\u00edci, \u017ee funkce SUMIF aplikace Excel 2013 je u\u017eite\u010dn\u00fdm n\u00e1strojem pro s\u010d\u00edt\u00e1n\u00ed dat na z\u00e1klad\u011b ur\u010dit\u00fdch krit\u00e9ri\u00ed. V\u00fdpo\u010dty m\u016f\u017eete prov\u00e1d\u011bt efektivn\u011b p\u0159i pou\u017eit\u00ed spr\u00e1vn\u00e9 syntaxe a pochopen\u00ed textov\u00fdch podm\u00ednek. Funkce SUMIFS je u\u017eite\u010dn\u00e1 pro p\u0159\u00edpady se slo\u017eit\u011bj\u0161\u00edmi po\u017eadavky. Excel disponuje velk\u00fdm mno\u017estv\u00edm technik manipulace s daty a zdokonalen\u00ed se v t\u011bchto postupech m\u016f\u017ee v\u00fdrazn\u011b zlep\u0161it va\u0161e dovednosti v oblasti anal\u00fdzy dat.<\/p><\/div>\n

\n
FAQ<\/div>\n
\n
Jak se pou\u017e\u00edv\u00e1 funkce Sumif mezi dv\u011bma \u010d\u00edsly?<\/div>\n

Chcete-li pou\u017e\u00edt funkci SUMIF mezi dv\u011bma \u010d\u00edsly, provedete v aplikaci Excel 2013 n\u00e1sleduj\u00edc\u00ed \u00fakony: Otev\u0159ete pracovn\u00ed list aplikace Excel a pot\u00e9 vyberte bu\u0148ku, ve kter\u00e9 chcete zobrazit v\u00fdsledek. <\/p>\n

<\/div>\n

2. Vypl\u0148te bu\u0148ku pomoc\u00ed vzorce „=SUMIF(„. 3. Pot\u00e9 vyberte sadu bun\u011bk, kter\u00e9 chcete analyzovat. Hodnoty, kter\u00e9 chcete se\u010d\u00edst, by m\u011bly spadat do tohoto rozsahu. 4. Po v\u00fdb\u011bru rozsahu p\u0159idejte \u010d\u00e1rku (,), abyste jej odd\u011blili od n\u00e1sleduj\u00edc\u00edho zad\u00e1n\u00ed. 5. Na tomto m\u00edst\u011b zadejte rozsah krit\u00e9ri\u00ed. Hodnoty, kter\u00e9 chcete porovnat, jsou zahrnuty v tomto rozsahu bun\u011bk. Mezi rozsah krit\u00e9ri\u00ed a n\u00e1sleduj\u00edc\u00ed parametr vlo\u017ete dal\u0161\u00ed \u010d\u00e1rku (,). <\/p>\n

<\/div>\n

6. 7. Zadejte po\u017eadavky. V tomto p\u0159\u00edpad\u011b se zadaj\u00ed dv\u011b cel\u00e1 \u010d\u00edsla, mezi kter\u00fdmi chcete se\u010d\u00edst \u00fadaje. <\/p>\n

<\/div>\n

8. Zadejte „)“ pro uzav\u0159en\u00ed z\u00e1vorek a stiskn\u011bte kl\u00e1vesu Enter pro v\u00fdpo\u010det sou\u010dtu. <\/p>\n

<\/div>\n

Vezm\u011bme si p\u0159\u00edpad, kdy chcete se\u010d\u00edst v\u0161echny hodnoty mezi 20 a 50, kter\u00e9 se nach\u00e1zej\u00ed v bu\u0148k\u00e1ch A1 a\u017e A10. To by byl vzorec: =SUMIF(A1:A10,“>20″,A1:A10, „50“). <\/p>\n

<\/div>\n

V\u0161echny hodnoty v rozsahu A1 a\u017e A10, kter\u00e9 jsou v\u011bt\u0161\u00ed ne\u017e 20 a men\u0161\u00ed ne\u017e 50, budou se\u010dteny pomoc\u00ed tohoto vzorce. Chcete-li vyhov\u011bt sv\u00fdm jedine\u010dn\u00fdm po\u017eadavk\u016fm, upravte rozsah a krit\u00e9ria. <\/p>\n<\/div>\n

\n
Jak v aplikaci Excel se\u010dtu konkr\u00e9tn\u00ed bu\u0148ky?<\/div>\n

V aplikaci Excel m\u016f\u017eete k se\u010dten\u00ed konkr\u00e9tn\u00edch bun\u011bk pou\u017e\u00edt funkci SUMIF. Zde je uveden postup, jak na to: <\/p>\n

<\/div>\n

1. Spus\u0165te aplikaci Excel 2013 a p\u0159ejd\u011bte na list, na kter\u00e9m m\u00e1 b\u00fdt v\u00fdpo\u010det proveden. 2. Vyberte rozsah bun\u011bk, kter\u00e9 chcete p\u0159idat. \u0158ekn\u011bme nap\u0159\u00edklad, \u017ee chcete se\u010d\u00edst hodnoty v bu\u0148k\u00e1ch A1 a\u017e A10. 3. Vyberte parametry, kter\u00e9 ur\u010d\u00ed, kter\u00e9 bu\u0148ky budou do sou\u010dtu zahrnuty. Zde m\u016f\u017ee b\u00fdt hodnota, rozsah hodnot nebo podm\u00ednka. \u0158ekn\u011bme, \u017ee chcete se\u010d\u00edst pouze bu\u0148ky ve sloupci B, kter\u00e9 maj\u00ed hodnotu „Jablka“. <\/p>\n

<\/div>\n

4. Do pr\u00e1zdn\u00e9ho pole zadejte funkci SUMIF. Funkce SUMIF m\u00e1 n\u00e1sleduj\u00edc\u00ed syntaxi: Rozsah, Krit\u00e9rium a Sou\u010det_Rozsah = SUMIF Rozsah bun\u011bk, ve kter\u00fdch chcete vyhodnotit krit\u00e9rium, je ur\u010den volbou „rozsah“. V na\u0161em p\u0159\u00edpad\u011b to budou bu\u0148ky B1 a\u017e B10. <\/p>\n

<\/div>\n

– Podm\u00ednka nebo hodnota, kterou hled\u00e1te, je argument „krit\u00e9rium“. V na\u0161em p\u0159\u00edkladu by to bylo „Jablka“. <\/p>\n

<\/div>\n

– Rozsah bun\u011bk, kter\u00e9 maj\u00ed b\u00fdt se\u010dteny, je ur\u010den parametrem „sum_range“. V na\u0161em p\u0159\u00edpad\u011b by to byly bu\u0148ky A1 a\u017e A10. Cel\u00fd vzorec je tedy =SUMIF(B1:B10, „Jablka“, A1:A10). <\/p>\n

<\/div>\n

5. Stisknut\u00edm kl\u00e1vesy Enter z\u00edsk\u00e1te sou\u010det jednotliv\u00fdch bun\u011bk podle zadan\u00fdch parametr\u016f. <\/p>\n

<\/div>\n

Na z\u00e1klad\u011b zadan\u00fdch podm\u00ednek pomoc\u00ed funkce SUMIF Excel vypo\u010d\u00edt\u00e1 sou\u010det dan\u00fdch bun\u011bk.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

What is the difference between Sumif and Sumifs? Difference Between Excel SUMIF and Excel SUMIFS Functions Both are logical SUM functions that find the SUM of a given range based on specified conditions. The only difference between Excel SUMIFS & SUMIF functions is that SUMIFs can check for multiple criteria at once, while SUMIF can … \u010c\u00edst d\u00e1l<\/a><\/p>\n","protected":false},"author":3899,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2258],"tags":[],"class_list":["post-7794","post","type-post","status-publish","format-standard","hentry","category-funkce-excelu"],"_links":{"self":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/7794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/users\/3899"}],"replies":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/comments?post=7794"}],"version-history":[{"count":1,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/7794\/revisions"}],"predecessor-version":[{"id":15376,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/7794\/revisions\/15376"}],"wp:attachment":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/media?parent=7794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/categories?post=7794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/tags?post=7794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}