i have big data file containing 200 script and 58 buyer and quantity that buyer buy in different script. i want to separate and sup up data per script per buyer number.
i have big data file containing 200 script and 58 buyer and quantity that buyer buy in different script. i want to separate and sup up data per script per buyer number.
Try
in F3
=SUMIFS($C$2:$C$15,$A$2:$A$15,$E3,$B$2:$B$15,F$2)
copy across and down
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks John, It work as you mention above. I am going to try it in the original data which is very big and mention again if there is any problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks