{"id":481218,"date":"2025-08-16T14:34:32","date_gmt":"2025-08-16T07:34:32","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=481218"},"modified":"2025-08-16T14:34:32","modified_gmt":"2025-08-16T07:34:32","slug":"ham-tong-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-tong-trong-excel\/","title":{"rendered":"15 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u1ed5ng trong Excel k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda"},"content":{"rendered":"

H\u00e0m t\u1ed5ng trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd v\u00e0 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn \u0111\u1ec3 t\u00ednh to\u00e1n nhanh ch\u00f3ng c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng d\u1eef li\u1ec7u. Nh\u1edd t\u00ednh linh ho\u1ea1t, h\u00e0m n\u00e0y kh\u00f4ng ch\u1ec9 \u00e1p d\u1ee5ng cho vi\u1ec7c c\u1ed9ng c\u00e1c con s\u1ed1 \u0111\u01a1n gi\u1ea3n m\u00e0 c\u00f2n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi nhi\u1ec1u h\u00e0m kh\u00e1c \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p. T\u1eeb nhu c\u1ea7u t\u00ednh to\u00e1n doanh thu, chi ph\u00ed \u0111\u1ebfn ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u th\u1ed1ng k\u00ea, h\u00e0m t\u1ed5ng lu\u00f4n \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng, gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 n\u00e2ng cao hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd chia s\u1ebb 15 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM trong Excel k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda.<\/span><\/p>\n

15 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u1ed5ng trong Excel<\/span><\/h2>\n

Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, vi\u1ec7c t\u00ednh t\u1ed5ng d\u1eef li\u1ec7u l\u00e0 thao t\u00e1c c\u01a1 b\u1ea3n nh\u01b0ng l\u1ea1i c\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch th\u1ef1c hi\u1ec7n kh\u00e1c nhau t\u00f9y t\u00ecnh hu\u1ed1ng. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 15 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUM trong Excel k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda, gi\u00fap b\u1ea1n thao t\u00e1c nhanh ch\u00f3ng, ch\u00ednh x\u00e1c v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian.<\/span><\/p>\n

C\u00e1ch t\u00ednh h\u00e0m SUM trong Excel nhanh<\/span><\/h3>\n

B\u00e0i vi\u1ebft n\u00e0y th\u1ef1c hi\u1ec7n tr\u00ean Excel 2016, nh\u01b0ng b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 tr\u00ean Google Sheet, Excel 2010, 2013,\u2026 C\u00e1ch n\u00e0y gi\u00fap b\u1ea1n xem t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4 ho\u1eb7c c\u1ed9t m\u00e0 kh\u00f4ng c\u1ea7n nh\u1eadp b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng n\u00e0o trong Excel.<\/span><\/p>\n

B\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn to\u00e0n b\u1ed9 c\u1ed9t ho\u1eb7c qu\u00e9t c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n t\u00ednh. Sau \u0111\u00f3, nh\u00ecn xu\u1ed1ng g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi m\u00e0n h\u00ecnh, t\u1ea1i m\u1ee5c Sum s\u1ebd hi\u1ec3n th\u1ecb t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb v\u1eeba ch\u1ecdn.<\/span><\/p>\n

V\u00ed d\u1ee5: N\u1ebfu mu\u1ed1n t\u00ednh t\u1ed5ng Doanh s\u1ed1 \u1edf c\u1ed9t C, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p chu\u1ed9t v\u00e0o c\u1ed9t C, v\u00e0 t\u1ed5ng s\u1ebd xu\u1ea5t hi\u1ec7n ngay \u1edf m\u1ee5c Sum.<\/span><\/p>\n

\"ham-tong-trong-excel-2\"<\/picture><\/p>\n

Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y r\u1ea5t ti\u1ec7n l\u1ee3i khi c\u1ea7n ki\u1ec3m tra nhanh d\u1eef li\u1ec7u, nh\u01b0ng kh\u00f4ng ph\u00f9 h\u1ee3p n\u1ebfu b\u1ea1n mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 tr\u1ef1c ti\u1ebfp t\u1ea1i m\u1ed9t \u00f4 \u0111\u1ec3 l\u00e0m b\u00e1o c\u00e1o ho\u1eb7c b\u00e0i t\u1eadp.<\/span><\/p>\n

T\u00ednh t\u1ed5ng tr\u00ean Excel b\u1eb1ng AutoSum<\/span><\/h3>\n

B\u01b0\u1edbc 1: M\u1edf b\u1ea3ng t\u00ednh Excel, di chuy\u1ec3n \u0111\u1ebfn \u00f4 tr\u1ed1ng ngay b\u00ean d\u01b0\u1edbi c\u00e1c \u00f4 d\u1eef li\u1ec7u c\u1ee7a c\u1ed9t c\u1ea7n t\u00ednh t\u1ed5ng.<\/span><\/p>\n

V\u00ed d\u1ee5: N\u1ebfu mu\u1ed1n t\u00ednh t\u1ed5ng Doanh s\u1ed1 \u1edf c\u1ed9t C, h\u00e3y ch\u1ecdn \u00f4 C6 (n\u1eb1m d\u01b0\u1edbi d\u1eef li\u1ec7u).<\/span><\/p>\n

\"ham-tong-trong-excel-3\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: V\u00e0o tab Home, nh\u00ecn sang b\u00ean ph\u1ea3i v\u00e0 ch\u1ecdn AutoSum. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u1ea1o c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng cho to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u trong c\u1ed9t. N\u1ebfu ch\u1ec9 mu\u1ed1n t\u00ednh m\u1ed9t s\u1ed1 \u00f4 nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n qu\u00e9t ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u tr\u01b0\u1edbc khi nh\u1ea5n AutoSum.<\/span><\/p>\n

\"ham-tong-trong-excel-4\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n

\"ham-tong-trong-excel-5\"<\/picture><\/p>\n

V\u1edbi c\u00e1ch t\u00ednh h\u00e0m t\u1ed5ng trong Excel n\u00e0y gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian nh\u1eadp c\u00f4ng th\u1ee9c, thao t\u00e1c nhanh v\u00e0 v\u1eabn \u0111\u1ea3m b\u1ea3o k\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb r\u00f5 r\u00e0ng.\u00a0<\/span><\/p>\n

T\u00ednh t\u1ed5ng trong Excel b\u1eb1ng h\u00e0m SUM<\/span><\/h3>\n

Ph\u01b0\u01a1ng ph\u00e1p t\u00ednh t\u1ed5ng b\u1eb1ng h\u00e0m SUM l\u00e0 c\u00e1ch c\u01a1 b\u1ea3n v\u00e0 ph\u1ed5 bi\u1ebfn nh\u1ea5t m\u00e0 b\u1ea5t k\u1ef3 ai s\u1eed d\u1ee5ng Excel c\u0169ng n\u00ean bi\u1ebft. C\u00e1ch n\u00e0y cho ph\u00e9p b\u1ea1n t\u00ednh t\u1ed5ng nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c c\u00e1c v\u00f9ng d\u1eef li\u1ec7u mong mu\u1ed1n.<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn chi ti\u1ebft:<\/span><\/p>\n

B\u01b0\u1edbc 1: M\u1edf Excel v\u00e0 di chuy\u1ec3n \u0111\u1ebfn \u00f4 tr\u1ed1ng \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. Nh\u1eadp c\u00f4ng th\u1ee9c =SUM(number1, number2, \u2026).<\/span><\/p>\n

V\u00ed d\u1ee5: T\u00ednh t\u1ed5ng Doanh s\u1ed1 t\u1eeb \u00f4 C2 \u0111\u1ebfn C5, b\u1ea1n nh\u1eadp =SUM(C2:C5). Thay v\u00ec g\u00f5 th\u1ee7 c\u00f4ng, b\u1ea1n c\u00f3 th\u1ec3 qu\u00e9t ch\u1ecdn tr\u1ef1c ti\u1ebfp c\u00e1c \u00f4 c\u1ea7n t\u00ednh.<\/span><\/p>\n

\"ham-tong-trong-excel-6\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3.<\/span><\/p>\n

L\u01b0u \u00fd: Khi nh\u1eadp h\u00e0m, c\u1ea7n vi\u1ebft \u0111\u00fang t\u00ean h\u00e0m l\u00e0 SUM. N\u1ebfu vi\u1ebft sai, Excel s\u1ebd b\u00e1o l\u1ed7i #NAME? v\u00e0 kh\u00f4ng hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n

T\u00ednh t\u1ed5ng nh\u1eefng \u00f4 \u0111\u01b0\u1ee3c l\u1ecdc b\u1eb1ng Subtotal<\/span><\/h3>\n

Ngo\u00e0i c\u00e1c c\u00e1ch t\u00ednh h\u00e0m t\u1ed5ng trong Excel tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng trong Excel b\u1eb1ng h\u00e0m SUBTOTAL \u2013 m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p n\u00e2ng cao h\u01a1n so v\u1edbi AutoSum. \u0110i\u1ec3m \u0111\u1eb7c bi\u1ec7t c\u1ee7a c\u00e1ch n\u00e0y l\u00e0 cho ph\u00e9p l\u1ecdc v\u00e0 ch\u1ec9 t\u00ednh t\u1ed5ng nh\u1eefng gi\u00e1 tr\u1ecb b\u1ea1n mong mu\u1ed1n, r\u1ea5t h\u1eefu \u00edch khi x\u1eed l\u00fd b\u1ea3ng t\u00ednh c\u00f3 h\u00e0ng ngh\u00ecn d\u1eef li\u1ec7u ho\u1eb7c d\u1eef li\u1ec7u s\u1ed1 xen k\u1ebd ch\u1eef.<\/span><\/p>\n

B\u01b0\u1edbc 1: M\u1edf file Excel c\u1ea7n t\u00ednh t\u1ed5ng. Ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng b\u1ea5t k\u1ef3 \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. Tr\u00ean thanh c\u00f4ng c\u1ee5, v\u00e0o tab Data v\u00e0 ch\u1ecdn Filter \u0111\u1ec3 b\u1eadt ch\u1ebf \u0111\u1ed9 l\u1ecdc d\u1eef li\u1ec7u.<\/span><\/p>\n

\"ham-tong-trong-excel-7\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: \u1ede c\u1ed9t c\u1ea7n t\u00ednh t\u1ed5ng, nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean nh\u1ecf. Trong b\u1ea3ng t\u00f9y ch\u1ecdn hi\u1ec7n ra, b\u1ecf t\u00edch Select All \u0111\u1ec3 b\u1ecf ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u.<\/span><\/p>\n

\"ham-tong-trong-excel-8\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: Trong \u00f4 Search, nh\u1eadp t\u1eeb kh\u00f3a ho\u1eb7c gi\u00e1 tr\u1ecb c\u1ea7n l\u1ecdc. V\u00ed d\u1ee5: n\u1ebfu mu\u1ed1n l\u1ecdc c\u00e1c d\u1eef li\u1ec7u ch\u1ee9a s\u1ed1 0, nh\u1eadp 0 r\u1ed3i nh\u1ea5n OK.<\/span><\/p>\n

\"ham-tong-trong-excel-9\"<\/picture><\/p>\n

B\u01b0\u1edbc 4: Sau khi l\u1ecdc, ch\u1ec9 nh\u1eefng gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p m\u1edbi hi\u1ec3n th\u1ecb. B\u1ea1n v\u00e0o tab Home, ch\u1ecdn AutoSum, sau \u0111\u00f3 nh\u1ea5n Enter. H\u00e0m SUBTOTAL s\u1ebd t\u1ef1 \u0111\u1ed9ng t\u00ednh t\u1ed5ng cho c\u00e1c d\u1eef li\u1ec7u \u0111\u00e3 l\u1ecdc, b\u1ecf qua d\u1eef li\u1ec7u b\u1ecb \u1ea9n.<\/span><\/p>\n

\"ham-tong-trong-excel-10\"<\/picture><\/p>\n

T\u00ednh t\u1ed5ng trong Excel b\u1eb1ng c\u00e1ch chuy\u1ec3n d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng<\/span><\/h3>\n

Ph\u01b0\u01a1ng ph\u00e1p cu\u1ed1i c\u00f9ng m\u00e0 m\u00ecnh mu\u1ed1n gi\u1edbi thi\u1ec7u l\u00e0 t\u00ednh t\u1ed5ng b\u1eb1ng c\u00e1ch chuy\u1ec3n d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng (Table) trong Excel. C\u00e1ch n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n t\u00ednh t\u1ed5ng nhanh ch\u00f3ng, m\u00e0 c\u00f2n t\u1ef1 \u0111\u1ed9ng th\u00eam m\u1ed9t h\u00e0ng Total ph\u00eda d\u01b0\u1edbi c\u00f9ng c\u1ee7a b\u1ea3ng \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.<\/span><\/p>\n

B\u01b0\u1edbc 1: M\u1edf file Excel c\u1ea7n t\u00ednh t\u1ed5ng v\u00e0 qu\u00e9t to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u mu\u1ed1n t\u00ednh.<\/span><\/p>\n

\"ham-tong-trong-excel-11\"<\/picture><\/p>\n

B\u01b0\u1edbc 2: Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm Ctrl + T \u0111\u1ec3 chuy\u1ec3n v\u00f9ng d\u1eef li\u1ec7u th\u00e0nh b\u1ea3ng. N\u1ebfu d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3 ti\u00eau \u0111\u1ec1, t\u00edch ch\u1ecdn \u00f4 My table has headers, sau \u0111\u00f3 nh\u1ea5n OK trong h\u1ed9p tho\u1ea1i Create Table.<\/span><\/p>\n

\"\"<\/picture><\/p>\n

B\u01b0\u1edbc 3: Tr\u00ean thanh c\u00f4ng c\u1ee5, v\u00e0o tab Design (ho\u1eb7c Table Design trong phi\u00ean b\u1ea3n m\u1edbi), t\u00edch v\u00e0o \u00f4 Total Row. Ngay l\u1eadp t\u1ee9c, ph\u00eda d\u01b0\u1edbi b\u1ea3ng s\u1ebd xu\u1ea5t hi\u1ec7n h\u00e0ng Total.<\/span><\/p>\n

\"ham-tong-trong-excel-13\"<\/picture><\/p>\n

B\u01b0\u1edbc 4: \u1ede c\u1ed9t c\u1ea7n t\u00ednh t\u1ed5ng, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn lo\u1ea1i ph\u00e9p t\u00ednh trong \u00f4 Total, m\u1eb7c \u0111\u1ecbnh l\u00e0 SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng, ho\u1eb7c thay \u0111\u1ed5i sang c\u00e1c ph\u00e9p t\u00ednh kh\u00e1c nh\u01b0 Average, Count,\u2026 n\u1ebfu mu\u1ed1n.<\/span><\/p>\n

T\u00ednh h\u00e0m t\u1ed5ng trong Excel v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng h\u00e0m SUMIF<\/span><\/h3>\n

H\u00e0m SUMIF trong Excel cho ph\u00e9p b\u1ea1n t\u00ednh t\u1ed5ng d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3, r\u1ea5t h\u1eefu \u00edch khi c\u1ea7n l\u1ecdc v\u00e0 c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh thay v\u00ec c\u1ed9ng to\u00e0n b\u1ed9 d\u1eef li\u1ec7u.<\/span><\/p>\n

V\u00ed d\u1ee5: B\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng ti\u1ec1n Th\u01b0\u1edfng cho nh\u1eefng nh\u00e2n vi\u00ean c\u00f3 Doanh s\u1ed1 > 20.000.000.<\/span><\/p>\n

B\u01b0\u1edbc 1: Ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng \u0111\u1ec3 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. Nh\u1eadp c\u00f4ng th\u1ee9c:<\/span><\/p>\n

=SUMIF(C2:C5,”>20000000″,D2:D5)<\/span><\/p>\n

\"ham-tong-trong-excel-14\"<\/picture><\/p>\n

Gi\u1ea3i th\u00edch c\u00f4ng th\u1ee9c:<\/span><\/p>\n