How to use SUMPRODUCT WITH IF CONDITION(S) in EXCEL

preview_player
Показать описание
How to use SUMPRODUCT WITH IF CONDITION(S) in EXCEL

=SUMPRODUCT(--($B$3:$B$12="Nicola"),$D$3:$D$12,$E$3:$E$12)

#excel
#exceltips
#exceltutorial
Рекомендации по теме
Комментарии
Автор

Dear awesome viewers!

Thank you for your amazing engagement! Remember, the most liked comment gets pinned – so start liking your favorites now!


Your support means the world to me. Let's keep the conversation going!

Thank You!

realmehranvahedi
Автор

Thanks for sharing. Just what I needed.

gertzen
Автор

How make the loop for the sumproduct function in excel?

alessandrorosati
Автор

Thank you very much for the super helpful video. Your kind effort is deeply appreciated.

TrongYangLim
Автор

Hello, thanks for the video, very helpful.

luisvayas
Автор

Hi, thank you for the video and explanation.

Julianfckl