Sign Up

Mendaftar untuk memulai bertanya, menjawab pertanyaan dan terhubung dengan angota Excelkita

Have an account? Sign In

Have an account? Sign In Now

Sign In

Masuk untuk memulai bertanya, menjawab pertanyaan dan terhubung dengan angota Excelkita

Sign Up Here

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lupa password? silahkan masukan email address. link reset password akan dikirimkan melalui email.

Have an account? Sign In Now

You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

ExcelKita Logo ExcelKita Logo
Sign InSign Up

ExcelKita

ExcelKita Navigation

  • Home
  • Blog
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
Home/ Questions/Q 344
Next
Answered
Asked: June 30, 20222022-06-30T11:26:11+00:00 2022-06-30T11:26:11+00:00In: Formula

Bagaimana Menjumlahkan Data Sesuai Kode Text

Anonymous
Anonymous

Maaf para suhu, bagaimana menyelesaikan soal ini menjadi lebih mudah

midoffsetsumproduct
  • 1
  • 2 2 Answers
  • 34 Views
  • 0 Followers
  • 0
Share
  • Facebook
  • Report
Leave an answer

Leave an answer
Cancel reply

Browse

2 Answers

  • Voted
  • Oldest
  • Recent
  • Random
  1. Best Answer
    Andi Setiadi Enlightened
    2022-06-30T11:52:05+00:00Added an answer on June 30, 2022 at 11:52 am
    Bagaimana Menjumlahkan Data Sesuai Kode Text

    Masing-masing hurup bisa dipisahkan dengan MID didalam SUMPRODUCT agar bisa dipecah menjadi ARRAY hasilnya gunakan CODE untuk mengubah A,B,C menjadi Index Number

    =SUMPRODUCT(CODE(MID(C4,ROW(OFFSET($A$1,,,LEN(C4),1)),1))-64)

     

    • 0
    • Reply
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
      • Report
  2. Andi Setiadi Enlightened
    2022-06-30T12:41:05+00:00Added an answer on June 30, 2022 at 12:41 pm

    Jika Nilai A,B,C tidak beruaturan dan akan mengunakan Table, bisa gunakan VLOOKUP

    =SUMPRODUCT(VLOOKUP(MID(D5,ROW(OFFSET($A$1,,,LEN(D5),1)),1),$A$3:$B$7,2,0))

    • 0
    • Reply
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
      • Report

Sidebar

Ask A Question

Stats

  • Questions 30
  • Answers 21
  • Best Answers 21
  • Users 36
  • Popular
  • Answers
  • Anonymous

    Rumus Urut Dengan Spin Button

    • 3 Answers
  • Anonymous

    Bagaimana Menjumlahkan Data Sesuai Kode Text

    • 2 Answers
  • Anonymous

    Bagaimana memberi warna pada bilangan bulat saja

    • 1 Answer
  • Andi Setiadi
    Andi Setiadi added an answer Bisa dengan menggunakan IF dan YEAR untuk mengecek tahu lahir… December 6, 2022 at 8:32 am
  • Andi Setiadi
    Andi Setiadi added an answer Misalkan tanggal 27 Oktober 2022 ada di kolom A1 Cara… October 21, 2022 at 11:21 am
  • Andi Setiadi
    Andi Setiadi added an answer Bisa gunakan REGEXEXTRACT =REGEXEXTRACT(A2,"= Rp.(\S+)") October 21, 2022 at 11:11 am

Related Questions

  • Anonymous

    Formula Tanggal hari kamis akhir bulan

    • 0 Answers
  • Anonymous

    Rumus Untuk Keterangan Tahun Millenial , Generation X atau Generasi ...

    • 1 Answer
  • Anonymous

    Bagaimana Mencari Hari Tertentu Terdekat dari Tanggal yang di tentukan

    • 1 Answer

Trending Tags

and choose concatenate conditional formating countif day eomonth find formula frequency hyperlink if index left len lookup macro max mid min mod networkday.intl offset question quotient randbetween regexextract right rumus setting sign sumif sumproduct text trend upper vba vlookup weekday wildcard workday.intl year

Explore

  • Home
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Tags
  • Badges
  • Users
  • Help
  • Our Blog
    • Excelnoob.com
    • ArrayFormula.com
  • YouTube

Footer

ExcelKita

Excelkita adalah tempat diskusi, bertanya, tanya jawab seputar Microsoft Excel dan Spreadsheets.

About Us

  • Meet The Team
  • Blog
  • About Us
  • Contact Us

Legal Stuff

  • Terms of Use
  • Privacy Policy
  • Cookie Policy

Help

  • Knowledge Base
  • Support

Follow

© 2022 ExcelKita. All Rights Reserved
With Love by Andi Setiadi

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.