Forum Discussion
Excel Formula Help
It's hard to suggest any formula unless you provide more details like what are those criteria, where to look for them, what to be sum etc.
I would suggest you to upload a sample file and mock up the desired output manually to show us what exactly you are trying to achieve.
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.