Hello,
I am needing some help and don't have the experience to understand how to go about it. I have attached a file in which i received product from vendors and i am hoping to have each value spent on that vendor (VENDOR LOG) summed under each month in another tab(SPEND CAD). I have been told to use "SUMIFS" or "ARRAY" but nothing has worked thus far... any help is appreciated!!
-Lost and Confused..
View attachment EXAMPE_1.xls
I am needing some help and don't have the experience to understand how to go about it. I have attached a file in which i received product from vendors and i am hoping to have each value spent on that vendor (VENDOR LOG) summed under each month in another tab(SPEND CAD). I have been told to use "SUMIFS" or "ARRAY" but nothing has worked thus far... any help is appreciated!!
-Lost and Confused..
View attachment EXAMPE_1.xls