C
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.
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.