If x and y and date then total

I used B2 to specify the Brand (Brand or Company in your sample file), and C2 to specify the month number (1=January, 12=December etc.), and then used this formula in D2 to get the total:

=SUMIFS(Sheet2!D:D,Sheet2!A:A,A2,Sheet2!C:C,B2,Sheet2!B:B,">="&DATE(2022,C2,1),Sheet2!B:B,"<="&EOMONTH(DATE(2022,C2,1),0))

You can obviously change the values in A2:C2 to get other totals.

Hope this helps.

Pete

Entered in what you said and was not able to produce a total.

Re-read my first sentence. I used D2 for the formula, as that gave me room to use C2 for the month and B2 for the brand.

Pete

Okay. Thought I did that. Just tried it again and it WORKED. You were right. Is there any way I can put those two options within the formula. 1 for January and "Brand" for brand? That way I don't have to dirty up the spreadsheet with more columns. THANK YOU!

I replaced B2 with "Brand" and C2 with 1 and achieved the result. Thank you for your help. I really appreciate it.

That's good to hear, and thanks for the rep.

I was just trying to make it more flexible for you, so that you could change the brand and/or the month without having to modify the formula.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete