Hi,
I am not sure if this is possible in its current format, however I need to find all occurrences of each supplier over a given period (i.e start date & end date) and add their corresponding invoice totals to get the total spend for that period.
Attached is a sample of the data set.
I have tried using SUMPRODUCT but have only managed to get it to calculate how many times a given supplier is shown in the period but not sum their invoice totals.
i.e =SUMPRODUCT((A2:A15>=B18)*(A2:A15<=B19)*(C2:X15=A23)) --> when i have tried adding arguments to this formula to add invoice totals, I get #value or #N/A.
Any assistance would be most appreciated.
Bookmarks