Forum Discussion

Copper Contributor

Jun 16, 2022

IF statement based on multiple columns.

Vendor 1 Vendor 2 Vendor 3 Vendor Master ABC BCD CDE Hi everyone, I'm trying to put up a IF formula for the following scenario. But I'm facing diffic...

BI & Data Analysis

excel

Formulas and Functions

office 365

Power BI

RaquelJ

Copper Contributor

Hi Charla74 ,

How about if statement to add multiple columns? how to summarize it.

Thank you so much.

Lorenzo

Silver Contributor

Nov 04, 2023

RaquelJ

in B17 then copy right and dow:

=SUMPRODUCT( ($B$3:$J$3=B$15) * ($A$5:$A$8=$A17) * $B$5:$J$8)

Forum Discussion

IF statement based on multiple columns.

Share

Resources