hello all,
i am looking for some formula index/match with sheet "source" as input data and sheet "output" as report...
how can do it??
please, see my workbook attached..
thanks and much appreciated...
john m
hello all,
i am looking for some formula index/match with sheet "source" as input data and sheet "output" as report...
how can do it??
please, see my workbook attached..
thanks and much appreciated...
john m
Hi
Paste this formula to Output sheet f3 cell and drag right
=SUMIFS(source!J:J,source!$H:$H,source!$C3,source!$I:$I,output!$D3)*$E3
Formula considers that there is only one BUMN-TT criterias
Appreciate the help? CLICK *
thanks AZ-Xl, but i am missing...
here is my new sample (with expected desired start from B3 down right)
Hope it works bro
IT'S GREAT, BRO!!!
many thanks, and my star for you....
You're welcome...nice feedback too
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks