Hi Guys,
would this 2 be possible to be combined?
heres a scenario:
this is the simplest formula. but the problem is, i needed to use Sumifs to capture selected datas only.
i Tried this:
SUMIFS(Dump!D:D,Dump!B:B,Summary!$A$1,Dump!C:C,Summary!E26) would be what should be like the Column C in the first image
SUMIFS(Dump!G:G,Dump!B:B,Summary!$A$1,Dump!C:C,Summary!E26) would be what should be like the Column B in the first image
would it be possible?
Thank you in Advance!
would this 2 be possible to be combined?
heres a scenario:
this is the simplest formula. but the problem is, i needed to use Sumifs to capture selected datas only.
i Tried this:
SUMIFS(Dump!D:D,Dump!B:B,Summary!$A$1,Dump!C:C,Summary!E26) would be what should be like the Column C in the first image
SUMIFS(Dump!G:G,Dump!B:B,Summary!$A$1,Dump!C:C,Summary!E26) would be what should be like the Column B in the first image
would it be possible?
Thank you in Advance!