{"id":4771,"date":"2024-12-08T08:42:00","date_gmt":"2024-12-08T08:42:00","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/ham-sumif-trong-google-trang-tinh-cach-su-dung-va-vi-du\/"},"modified":"2024-12-08T08:42:00","modified_gmt":"2024-12-08T08:42:00","slug":"ham-sumif-trong-google-trang-tinh-cach-su-dung-va-vi-du","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/ham-sumif-trong-google-trang-tinh-cach-su-dung-va-vi-du\/","title":{"rendered":"H\u00e0m SUMIF trong Google Trang t\u00ednh \u2013 C\u00e1ch s\u1eed d\u1ee5ng v\u00e0 v\u00ed d\u1ee5"},"content":{"rendered":"
\n

B\u00e0i vi\u1ebft n\u00e0y H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF trong Google Sheets<\/strong> <\/a>\u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f3 \u0111i\u1ec1u ki\u1ec7n th\u00f4ng qua c\u00e1c v\u00ed d\u1ee5 c\u00f4ng th\u1ee9c cho v\u0103n b\u1ea3n, s\u1ed1 v\u00e0 ng\u00e0y th\u00e1ng v\u00e0 c\u00e1ch t\u00ednh t\u1ed5ng v\u1edbi nhi\u1ec1u ti\u00eau ch\u00ed.<\/span><\/em><\/p>\n

M\u1ed9t s\u1ed1 ch\u1ee9c n\u0103ng ti\u1ec7n l\u1ee3i trong Google Sheets<\/strong><\/a> l\u00e0 nh\u1eefng ch\u1ee9c n\u0103ng gi\u00fap b\u1ea1n t\u00f3m t\u1eaft v\u00e0 ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u. H\u00f4m nay, ch\u00fang ta s\u1ebd c\u00f9ng t\u00ecm hi\u1ec3u m\u1ed9t trong nh\u1eefng h\u00e0m nh\u01b0 v\u1eady \u2013 h\u00e0m SumIf \u2013 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c \u00f4 theo \u0111i\u1ec1u ki\u1ec7n. Tr\u01b0\u1edbc khi \u0111i v\u00e0o c\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00fa ph\u00e1p v\u00e0 c\u00f4ng th\u1ee9c, ch\u00fang ta h\u00e3y b\u1eaft \u0111\u1ea7u v\u1edbi m\u1ed9t v\u00e0i l\u01b0u \u00fd quan tr\u1ecdng.<\/span><\/p>\n

Google Trang t\u00ednh c\u00f3 hai ch\u1ee9c n\u0103ng \u0111\u1ec3 c\u1ed9ng c\u00e1c s\u1ed1 d\u1ef1a tr\u00ean c\u00e1c \u0111i\u1ec1u ki\u1ec7n: SUMIF v\u00e0 SUMIFS. C\u00e1i tr\u01b0\u1edbc ch\u1ec9 \u0111\u00e1nh gi\u00e1 m\u1ed9t \u0111i\u1ec1u ki\u1ec7n trong khi c\u00e1i sau c\u00f3 th\u1ec3 ki\u1ec3m tra nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng m\u1ed9t l\u00fac. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd ch\u1ec9 t\u1eadp trung v\u00e0o h\u00e0m SUMIF, vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m SUMIFS s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ec1 c\u1eadp trong b\u00e0i vi\u1ebft ti\u1ebfp theo nh\u00e9.<\/span><\/p>\n

N\u1ebfu b\u1ea1n bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng SUMIF trong Excel<\/strong> <\/a>th\u00ec h\u00e0m<\/strong> SUMIF trong Google Trang t\u00ednh<\/strong> s\u1ebd n\u1eb1m trong t\u1ea7m tay b\u1ea1n v\u00ec c\u01a1 b\u1ea3n c\u1ea3 hai \u0111\u1ec1u gi\u1ed1ng nhau. Nh\u01b0ng \u0111\u1eebng v\u1ed9i b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y \u2013 b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y m\u1ed9t s\u1ed1 c\u00f4ng th\u1ee9c SUMIF r\u1ea5t h\u1eefu \u00edch m\u00e0 b\u1ea1n ch\u01b0a bi\u1ebft \u0111\u1ea5y!<\/span><\/p>\n

\n

Xem nhanh<\/p>\n