Multiple criteria in 2 different columns for a sum in a 3rd column
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) D2:D100,(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. |
Multiple criteria in 2 different columns for a sum in a 3rd column
Hi,
try =sumproduct(--(masterdata!$d$2:$d$100="Infrastructure"),--(masterdata!$l$2:$l$100="PO"),masterdata!$n$2:$n$1 00) "Cyn" wrote: 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) D2:D100,(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. |
Multiple criteria in 2 different columns for a sum in a 3rdcolumn
And if Cyn wants to list the sum of N2:N100 for all occuring different
values in D2:D100 and L2:L100: Select a sufficiently long area (i.e. 20 rows) and 3 columns and array- enter: =Sfreq(D2:D100,L2:L100,N2:N100) Sfreq you will find he http://www.sulprobil.com/html/sfreq.html Regards, Bernd |
Multiple criteria in 2 different columns for a sum in a 3rd co
Thank you,
I saw what I was missing it works now. "Eduardo" wrote: Hi, try =sumproduct(--(masterdata!$d$2:$d$100="Infrastructure"),--(masterdata!$l$2:$l$100="PO"),masterdata!$n$2:$n$1 00) "Cyn" wrote: 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) D2:D100,(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. |
All times are GMT +1. The time now is 10:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com