Excelの合計が合わない時の裏ワザ！
Synopsis
15年Excel使ってるけど、初めて知った… 」 そんな声が続出してるのがこの関数 AGGREGATE（アグリゲート）関数！
You Might Also Like
![[Excel] What, you don't change the cell width?! The new standard for creating tables](https://i.ytimg.com/vi/ZoRE4q-4hqA/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGABwAcABBvABAfgBtgiAAoAPigIMCAAQARhOIGUoRTAP&rs=AOn4CLDydodJ2HUAQbZ9GtVtIhHmu2tvBg)
![【1分で学べる】Excelでsum関数以外のあまり知られていない合計の出し方 [エクセル小技・小ネタテクニック] #Shorts](https://i.ytimg.com/vi/PBalFKTl_iI/hq720_2.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGABwAcABBvABAfgBlAOAAtAFigIMCAAQARgeIGUoNDAP&rs=AOn4CLAvKEYrvEm5n_EGiDBj3m6E4OlBkA)
![[Excel] Secret tricks that don't involve merging cells](https://i.ytimg.com/vi/nX7Q1k-g_u8/hq720.jpg?sqp=-oaymwE2CNAFEJQDSFXyq4qpAygIARUAAIhCGABwAcABBvABAfgBtgiAAoAPigIMCAAQARhlIGUoZTAP&rs=AOn4CLDngusAJXle3Ju-9zIvcbI8YLdhJQ)
Download Options
Choose a download method below. All links open in new tabs.
| Service | Features | Action |
|---|---|---|
| Ssvid |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
| SaveFrom |
MP4 & MP3 • HD Quality • Browser Extension Available
|
Download |
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.