Multiple criteria in 2 different columns for a sum in a 3rd column

[Cyn]

Trying to write a formula to fit this all info is on a different sheet in the
same workbook.

Masterdata(sheet name)( Column for 1st critera)
D2100,(Critera)"Infrastructure", (Column for 2nd critera), L2:L100
,(Critera)"PO", Sum N2:N100

My idea is that looking on the master data sheet if in Column D
"Infrastructure" is chosen and in column L "po" is chosen then it will add
totals in column N.

 

[Eduardo]

Hi,
try
=sumproduct(--(masterdata!$d$2:$d$100="Infrastructure"),--(masterdata!$l$2:$l$100="PO"),masterdata!$n$2:$n$100)

 

[Eduardo]

Hi,
try
=sumproduct(--(masterdata!$d$2:$d$100="Infrastructure"),--(masterdata!$l$2:$l$100="PO"),masterdata!$n$2:$n$100)

 

[Bernd P]

And if Cyn wants to list the sum of N2:N100 for all occuring different
values in D2100 and L2:L100:

Select a sufficiently long area (i.e. 20 rows) and 3 columns and array-
enter:
=Sfreq(D2100,L2:L100,N2:N100)

Sfreq you will find here:
http://www.sulprobil.com/html/sfreq.html

Regards,
Bernd

 

[Bernd P]

And if Cyn wants to list the sum of N2:N100 for all occuring different
values in D2100 and L2:L100:

Select a sufficiently long area (i.e. 20 rows) and 3 columns and array-
enter:
=Sfreq(D2100,L2:L100,N2:N100)

Sfreq you will find here:
http://www.sulprobil.com/html/sfreq.html

Regards,
Bernd

 

[Cyn]

Thank you,

I saw what I was missing it works now.

 

[Cyn]

Thank you,

I saw what I was missing it works now.