I want to use a SUMIF statement that will only sum items that meet 2 criteria that are located within 2 target areas.
Example:
column A has date
column B has part numbers
column C has cost
So I want to get a total cost of all of a particilar part number used within a certain date range.
The SUMIF statement worked perfect for only finding date and cost, but now I want to add a 3rd component into the mix.
Any experts out there that can help?
Thanks
Bookmarks