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

[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)

--
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 milis-belajar-e...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/0e7d0d51-9f39-4fc7-ad83-91ea37998f41n%40googlegroups.com.

[Indra Pramana Dwi Putra]

Hai Kak Odong Nando,

Mohon maaf sebelumnya Kak baru membalas emailnya..

Terima kasih banyak Kak atas bantuannya..

Salam Keberkahan,

Indra

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 milis-belajar-e...@googlegroups.com.
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.