![]() "D3" then matches the total sales (Range "SALES") to see how many Widgets (Range "Product") that also have a sub-criteria "Boxed" (Range "Subset") were sold by the same store in the same period.Ĭols E and F do the same for the other two outlets.ĬHALLENGE: The Code needs to distinguish between a "Widget" (Data in "Product" but "SUBSET" as blank) and a "Boxed Widget" (data in both "Product" and "SUBSET" columns). The Code SHOULD do this by matching everything sold by everyone (Range "SALES) against the PRODUCT and SUBSET sold by Outlet 1. ![]() ![]() "D2" should show how many Widgets (Range "PRODUCT") without any sub-criteria (Range "SUBSET") were sold by Store 1 in the month selected in C1 (Range "LOOKFOR"). Re: VBA 'sumifs' code allows 'IF' function for sub-criteria
0 Comments
Leave a Reply. |