[milis-belajar-excel] Sum dengan criteria tertentu

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] Sum dengan criteria tertentu

Indra Pramana Dwi Putra
Assalaamu ‘alaikum warahmatullaahi wabarakaatuh,

Selamat sore Bapak-Ibu.. mohon maaf.. jika ingin menghitung nilai total dengan criteria tertentu yang sebagaimana terlampir dalam email ini, bagaimana ya caranya?

Mohon maaf Bapak-Ibu..
Demikian disampaikan, terima kasih atas perhatian dan kerjasamanya.

Salam,
Indra

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/0e7d0d51-9f39-4fc7-ad83-91ea37998f41n%40googlegroups.com.

Sum dengan criteria tertentu.xlsx (12K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Sum dengan criteria tertentu

odong nando
hai indra,

klo masih mau mempertahankan value dari kolom docno, yg terlihat angka tp terbaca excel text, bukan angka, maka formulanya

=SUMPRODUCT(((B2:B6)*1<>40)*C2:C6)



On Tue, Feb 2, 2021 at 6:03 PM Indra Pramana Dwi Putra <[hidden email]> wrote:
Assalaamu ‘alaikum warahmatullaahi wabarakaatuh,

Selamat sore Bapak-Ibu.. mohon maaf.. jika ingin menghitung nilai total dengan criteria tertentu yang sebagaimana terlampir dalam email ini, bagaimana ya caranya?

Mohon maaf Bapak-Ibu..
Demikian disampaikan, terima kasih atas perhatian dan kerjasamanya.

Salam,
Indra

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/0e7d0d51-9f39-4fc7-ad83-91ea37998f41n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGZ5tN68BA0%2BUri_E_45MG4cU5x8GKPN%2B-31HDU9Jg5SxDLLVg%40mail.gmail.com.
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Sum dengan criteria tertentu

Indra Pramana Dwi Putra
Hai Kak Odong Nando,

Mohon maaf sebelumnya Kak baru membalas emailnya..

Terima kasih banyak Kak atas bantuannya..

Salam Keberkahan,
Indra

On Wed, Feb 3, 2021 at 11:05 AM odong nando <[hidden email]> wrote:
hai indra,

klo masih mau mempertahankan value dari kolom docno, yg terlihat angka tp terbaca excel text, bukan angka, maka formulanya

=SUMPRODUCT(((B2:B6)*1<>40)*C2:C6)



On Tue, Feb 2, 2021 at 6:03 PM Indra Pramana Dwi Putra <[hidden email]> wrote:
Assalaamu ‘alaikum warahmatullaahi wabarakaatuh,

Selamat sore Bapak-Ibu.. mohon maaf.. jika ingin menghitung nilai total dengan criteria tertentu yang sebagaimana terlampir dalam email ini, bagaimana ya caranya?

Mohon maaf Bapak-Ibu..
Demikian disampaikan, terima kasih atas perhatian dan kerjasamanya.

Salam,
Indra

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/0e7d0d51-9f39-4fc7-ad83-91ea37998f41n%40googlegroups.com.

--
You received this message because you are subscribed to a topic in the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/milis-belajar-excel/7i5_oTYH3JU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGZ5tN68BA0%2BUri_E_45MG4cU5x8GKPN%2B-31HDU9Jg5SxDLLVg%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAD7ajtb9vORWu%2Brn7qcqj7BPuUqyB0Bkq6C1XjgUHG6wr9Vn2Q%40mail.gmail.com.