Automatically translated.View original post

Find the function you are looking for in an instant!

2025/8/16 Edited to

... Read moreExcelって「関数が便利」と聞くけど、いざ作業すると“どの関数を使えばいいか分からない”が一番の壁でした。私がラクになったのは、暗記をやめて「探し方」を固定したことです。ここでは、関数一覧の見つけ方と、よく検索される計算系の実例(足し算・引き算の組み合わせ、複数条件カウント)をまとめます。 まず「関数一覧」の探し方。数式バーの[fx](関数の挿入)を押すと、カテゴリ別に関数が見られます。目的がぼんやりしているときは、検索欄に「合計」「年齢」「条件」みたいに日本語で入れるだけでも候補が出てくるので、関数名を思い出せない時に便利です。さらに、関数を入れ始めてから(例:=DA…)入力補助の候補から選ぶのも早いです。 次に「Excel 使い方 計算」系でつまずきやすいポイント。足し算は=SUM(A1:A10)が鉄板ですが、引き算や手数料などを混ぜるなら、私は“途中結果を分ける”ようにしています。例えば、B列が売上、C列が返品、D列が手数料なら、E2に=B2-C2-D2。合計を出したいなら=SUM(E2:E100)にしておくと、後から項目が増えても壊れにくいです。 「年齢計算」をするならDATEDIFが便利でした(ヘルプに出にくいので知らない人が多いです)。年齢(満年齢)だけなら、=DATEDIF(A1,TODAY(),"Y")。月も出したいなら=DATEDIF(A1,TODAY(),"Y")&"歳"&DATEDIF(A1,TODAY(),"YM")&"ヶ月"。さらに日まで出すなら"MD"も組み合わせると「○歳○ヶ月○日」の形にできます。※誕生日セルが日付形式になっているか(文字列になっていないか)は先に確認しました。 「SUMPRODUCT 複数条件 カウント」も実務でかなり使いました。例えば、A列が部署、B列が区分、C列が金額のとき、条件に合う件数なら =SUMPRODUCT((A2:A100="営業")*(B2:B100="完了")) 合計金額なら =SUMPRODUCT((A2:A100="営業")*(B2:B100="完了")*(C2:C100)) の形で作れます。IFとCOUNTIFSでもできますが、配列でまとめたい時にSUMPRODUCTが便利でした。 最後に、私が「便利な関数」を覚える代わりにやっていることは、よく使う型だけメモしておくことです。例:SUM(合計)、IF(条件分岐)、XLOOKUP(検索)、DATEDIF(年齢)、SUMPRODUCT(複数条件)。これだけでも、日々の事務作業はかなり時短になりました。

Related posts

Sign you are Dating a Mature Man ❤️
A mature man shows his growth in his mindset, actions, and interactions. Here are some key signs: 1. Emotional Stability - He doesn’t let his emotions control him. Instead of reacting impulsively, he approaches situations calmly and rationally. 2. Accountability - A mature man
TyBuggy

TyBuggy

2825 likes

Saved Her From Looking A Hot Mess: Before & After
Ladies, do you take-time out for yourself? Self-care is important because it supports your overall well-being and helps you function at your best. Here are a few key reasons: 🥰 1. Improves mental health – Reduces stress, anxiety, and emotional exhaustion. 2. Boosts physical health – Encou
JustShupier 💖

JustShupier 💖

2657 likes

A person's legs by a pool, one bronzed and one lighter, with a bottle of Vacation Instant Vacation Bronzing Lotion. Text reads "TRUST THE PROCESS Instant Tan W/ SPF" and "BEAUTY FINDS".
A person's lighter legs by a pool, holding a bottle of Vacation Instant Vacation Bronzing Lotion. Text reads "YOU NEED THIS! BEFORE... SWIPE FOR AFTER! BEFORE USE!".
A person's legs by a pool, one bronzed labeled "WITH" and one lighter labeled "WITHOUT", with arrows pointing to each leg.
🫶Instant Tan!!!!! ☀️ You need this for Vacation!! 🫶
I recently tried Vacation Tanning Unless after hearing some buzz, and I have to say—it delivered a pretty solid experience. The product (or salon) gives off that easy, beachy vibe right away, which really helps set the mood for a sun-kissed transformation. The application was smooth, the scent was
Valleymom | SAHM

Valleymom | SAHM

1944 likes

Adli's find!!!
Found a hidden gem at Aldi! ☕️✨ Ice Roast Instant Coffee that’s cheaper than Target and Walmart. If you’re looking for a great coffee deal, you might want to check this out! 🛒💸 #AldiFinds #CoffeeLovers #BudgetCoffee #AldiDeals #InstantCoffee
falsedestiny

falsedestiny

483 likes

A person taking a mirror selfie, with text overlay: 'How to find the Perfect Job on LinkedIn Using a secret tip HR recruiters use'. It serves as the title card for an article about job searching.
A LinkedIn profile screenshot for Michaela Jonsson, showing her professional details and a pink bubble highlighting 'It's called the Boolean String Method' as a job search technique.
Instructions on how to use Boolean strings for LinkedIn job searches, explaining the use of quotation marks for multi-word jobs, and 'AND' or 'OR' for combining search terms.
How to Search and Find Specialized Jobs for You!
As an HR intern, I learned a LOT of the tricks of the trade. As a specific RECRUITING intern, this is how we would look up perfect candidates for roles to fill. This works both ways!! If you’re in your job search, it can be so stressful to find jobs you qualify for, let alone alike. Use t
michaelajonsson

michaelajonsson

256 likes

Two women in swimsuits pose on a jet ski at sunset, with one raising her leg and the other making a peace sign. Overlay text reads "POV: you finally found your Best Friend," emphasizing the joy of a new friendship.
Two women in athletic wear pose on a tennis court, holding rackets and smiling. Overlay text discusses the challenge of making genuine friendships as an adult, highlighting the article's theme.
Two women in white robes enjoy an outdoor breakfast with a scenic ocean view. Overlay text states that making friends may not be as hard as one thinks, encouraging openness to connections.
HOW TO FIND A BEST FRIEND AS AN ADULT 🌷🤍
𝐇𝐄𝐋𝐋𝐎, 𝐃𝐑𝐄𝐀𝐌 𝐆𝐈𝐑𝐋𝐒 🦢 I thought it would be great to have an open discussion about making friends as an adult. 🌷 This task can seem discouraging as we get older because you may feel like it is awkward or you may not know where to start. ☁️ 𝙏𝙃𝙀 𝙏𝙍𝙐𝙏𝙃 𝘼𝘽𝙊𝙐𝙏 𝙈𝘼𝙆𝙄𝙉𝙂 𝙁𝙍𝙄𝙀𝙉𝘿𝙎 🫖 NOT SO BAD - It
Tyra Reneé

Tyra Reneé

492 likes

Instant dopamine for me 🌸
Love taking and looking at flower pics #flowers 🫶🏽 #pretty flowers #flowers🤍 #Lemon8Diary #flowersss
olivia

olivia

24 likes

A smiling woman with long brown hair is featured, with text overlay indicating the topic is about instant bronzing lotions for flawless tan skin.
A hand holds a light green tube of body perfecting lotion. The product is described as a body foundation that blurs imperfections for a gorgeous look.
A hand holds a bronze-colored tube of sun lotion with shimmer. The product is highlighted for its flawless coverage and subtle glow, ideal for maintaining a tan.
Favorite instant BRONZING lotion ✨🧴
Both of these instant bronzers are my FAVORITE!! I love having an instant bronzer especially because I love to self tan and it is perfect to use when your self tan is starting to fade and be in the “awkward” stage this blends everything nicely and keeps you looking nice and bronze. 🥰 #lemon8partne
Kaela Tripp

Kaela Tripp

94 likes

Quick mixing trick for instant vibe
#producer #musicproduction #music #musicproducer #audioengineer
OfficialJustinSheriff

OfficialJustinSheriff

1 like

A blurred image of a person with a pink flower graphic over their face, overlaid with the text 'how i INSTANTLY cure a TENSION HEADACHE'. The Lemon8 logo and username are at the bottom.
A blurred image of a person with a pink flower graphic, featuring text explaining tension headache causes and symptoms, alongside a diagram illustrating headache locations. The Lemon8 logo and username are visible.
A blurred image of a person with a pink flower graphic, displaying a list of neck and shoulder stretches for headache relief. The Lemon8 logo and username are at the bottom.
INSTANT HEADACHE RELIEF
I get tension headaches, often after a hard day of work 😪. here are some things that fix it pretty quick! ---> STRETCH ROUTINE 🤸‍♀️ I like to stretch out my shoulders, neck, and back. this helps relieve some tension in my muscles 🙂 - 20 chin tucks - neck rolls for 10 sec both directions
bee 🫖

bee 🫖

174 likes

A bowl of yellow medicine ball bombs, whole lemons, and a glass of tea, illustrating a Starbucks Medicine Ball recipe without lemonade, emphasizing no refined sugars, quick preparation, and customization.
An overhead shot displaying the ingredients for the medicine ball recipe: chopped lemons, ginger, raw honey, coconut water, and mint tea.
A collage showing the preparation steps for the medicine ball bombs, including blending lemons, ginger, and honey, then freezing the mixture into spherical ice cubes, with a 'PREP TIME: 5 MINS' overlay.
Instant Starbucks Medicine Ball 💛
This copycat Starbucks Medicine Ball recipe without lemonade only needs 5 ingredients. Just add two bombs to your favorite cup of tea for an instant pick-me-up! 😋 Why You’ll Love This Recipe 🤩 Ready in a Pinch: Do you feel under the weather? Forget the queues and make this Starbucks Medicine
Food Plus Words

Food Plus Words

16.2K likes

In An Instant 🌨️🏔️🌊
book review | In An Instant by Suzanne Redfearn ❄️ my rating: ⭐️⭐️⭐️⭐️⭐️ Setting: Laguna Beach & Big Bear, California 🌊 In an instant sixteen-year-old Finn Miller’s life is over. A fatal car wreck sends her and ten others tumbling down the side of a mountain in a blizzard. When surviva
chelsea

chelsea

95 likes

British Shorthair Kittens = Instant Happiness 😻
British Shorthair Kittens = Instant Happiness 😻 #britishshorthairkitten #kittenvideo #petsoftiktok #cats
BSH Kittens Looking for Homes

BSH Kittens Looking for Homes

99 likes

Another Instant Pot hack ❤️
#instantpot #quicksidedish #quickrecipes #easysidedish #pressurecooker #potatorecipes
Farm & Table

Farm & Table

256 likes

A woman in athletic wear sits on a yoga mat, smiling, with text overlay "YOGA POSES for quick BLOATING RELIEF" and social media handle.
A woman performs the "Knees Hugged to Chest" yoga pose on a mat, with instructions and benefits for relieving bloating and gas pains.
A woman demonstrates a "Spinal Twist" yoga pose on a mat, with text explaining how to do it and its benefits for stretching the stomach area and reducing bloat.
Yoga Poses for Instant Bloating Relief
Feeling bloated and uncomfortable? It's time to take control of your digestion and say goodbye to bloating. In this guide, we're going to explore five scientifically proven stretches that can help alleviate bloating and improve your gut health. Let's dive in and discover how these stret
Taylorsometimes

Taylorsometimes

494 likes

instant mood boosters
Feeling a little down or overwhelmed? Sunday scaries or having a blah day? What you’re feeling is valid and normal. Here are some ideas to try when you want to give your mood a little boost. ❣️ Stress and anxiety - Try going for a walk or practicing some breath work. Take a deep breath throug
gabrielleassaf

gabrielleassaf

52 likes

How To Make Instant Pot Beans from Scratch
This Instant Pot Pinto Beans recipe is a great way to get started with meal prep and cooking beans with an instant pot. It simplifies the process and ensures you won’t need to spend hours in the kitchen to have a bowlful of pinto beans. 🫘 The printable recipe can be found on my blog! 💚 Ingr
pbonabudget

pbonabudget

138 likes

A person with long, light blonde hair takes a mirror selfie in what appears to be a salon. Text overlay reads: '3 PRODUCTS THAT SAVED MY BLEACHED HAIR'.
Three pink and orange bottles and a tube of hair products are displayed. They are labeled 'matrix Insta Cure Build-A-Bond' and include a shampoo, conditioner, and liquid mask.
A pink bottle of 'matrix Insta Cure Build-A-Bond' shampoo is shown. Text overlay highlights its benefits: 'Cleans without stripping, helps reduce breakage'.
My top 3 recs for healthy looking bleached hair 💋
I am a natural blonde, but as I’ve gotten older it has darkened a bit. When my friend became a hair stylist, I went to her with hopes of getting that lighter blonde I always had. My hair is also naturally curly and dry, so she recommended me these products. I have her grab them for me when they’re
Gracie 🤎

Gracie 🤎

46 likes

From-Scratch Chicken N’ Dumplings 🐓🥘 (Instant Pot)
My FAVE chicken n’ dumplings recipe to use for meal prepping, comfort food, and something that’s just damn good! ☺️💖 (and it’s an #InstantPotRecipe so it’s faster!) I used 1 TBS beef bouillon paste with 3 1/2 cups of water instead of the chicken stock (I was out of the stock lol) and Hubby sa
MrsJustJessie

MrsJustJessie

61 likes

A collage showcasing various kitchen essentials like a blender, slow cooker, air fryer, griddle, and drinkware, all highlighted as budget-friendly finds.
A boxed blender with a clear pitcher containing a yellow liquid, alongside fruit, displayed with a price tag under $20.
A retail display featuring numerous black cooking utensils, including spatulas and slotted spoons, individually priced under $1.
Walmart Kitchen Findz (EVERYTHING IS UNDER $20)
I love me a good cheap kitchen find! 🤭 Discover Wallet-Friendly Walmart Kitchen Essentials: From Crockpots to Blenders, All Under $20! Elevate your culinary game with budget-friendly finds including crockpots, blenders, cooking utensils, griddles, toasters, measuring cups, and sets of plates, bowls
DkDiggz

DkDiggz

2063 likes

girl home starter kit every babe needs✨
Every girl home needs a foundation of comfort, function, and style ✨ That’s where your starter kit comes in! Think of it as the little building blocks that make your space feel cozy, organized, and like you. 🌸 Start with cozy comforts—fluffy pillows, soft throw blankets, and a signature candle s
Jessica | LIFESTYLE 💕

Jessica | LIFESTYLE 💕

18 likes

See more