Forum Discussion
Excel Formula Help
What I need is a formula to retrieve the sum of the dollars in column M in the Vendor Data tab. I need it based on column a in the vendor purchases tab. I also need it to be based on the individual vendors in the vendor data tab. I.E. Vendor purchases tab has 4201 in column a, the vendor data tab has this store under multiple vendors. I want Excel to sum the totals for each vendor for this store number. the first vendor is at cell A3 with different store numbers under it, then another vendor starting at cell A32. I will be downloading a new data tab each week so the data can change positions weekly based on the number of actual purchases per store. Under this example 4202 under 1 800 RADIATOR would total $374.60 for this example.
Thanks for the details.
I still suggest you to upload a small sample file with max 10 rows of data on both the Tabs along with the desired output mocked up manually to discard any confusion.
Please refer to the following image to know how to upload a sample file.
Subodh_Tiwari_sktneerI attached the spreadsheet
Try this and see if you get the desired output...
In D2
=SUMIF('Vendor Data'!A:A,A2,'Vendor Data'!M:M)
and then copy it down.
Subodh_Tiwari_sktneerThat does not do the trick. That just gives me the total for all vendors instead of each specific vendor. I need to be able to have Excel look up the vendor name first then bring back the purchase totals per store under just that vendor. I want it to be able to look them up that way no matter how many rows are below each vendor for each store.