Count values which meet specific criteria

Looks like to need COUNTIFS or SUMPRODUCT functions. Tyr with these OR upload a small sample workbook.

Hi aroujo,

Please upload a sample workbook. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi,

I'm thinking a Pivot Table is in your future. See the attached for an example of how I'd do this problem.

Hi araujo3rd,

Here is how I'd do your whole problem. See the attached.
I'd simply add to the bottom of the columns A - F more sales. You will put the cake name, size, how many, date and fill in the formula to do the month and week.
I've created a Dynamic Named Range called "CakesDNR" which will know how much data the Pivot Table is supposed to grab
I've created an Event Macro so the DNR will change if you change or fix or add any of the numbers.
The Pivot Table allows you to filter the months you want to see. This would do the whole problem for you so you can start baking those cakes.

You sir are a genius! thank you so much!

However could u please help me to alter the program so that the user first selects the cake design they would like (e.g. IRIS or Butterfly etc), Then followed by the due date its needed (Perhaps a drop down calandar?) then followed by the flavour (E.g chocolate or vanilla etc, also in a drop down list) then followed by the sizes offered (also a drop down list with the sizes)

Then in the pivot table is it possible to rather display the week of the month the order falls into rather than the actual week of the year. So if the order is between 01-07 december it will fall into week 1, 8-14 december into week 2, 15-21 december into week 3 and 22-31 december into week 4. That way it will make it easier to see exactly which cakes must be made in each week of the month! If this can be done my program will be hundreds!

Thank you so much for all ur help and quick responses

Hi araujo3rd,

My old profession, many years ago, was a teacher. I continued learning new things by finding good examples and understanding how they worked. I have given you a good example to grow from. The task is now yours, or others to improve upon. I believe in teaching people, as in "how to fish" and hate simply giving them answers where they never learn new things themselves. It is your turn to learn from this example.

Hey - OK,

You need to attach a list of all you possible cake types/names (IRIS, Butterfly, etc) and another list of all those colors you need. You should also tell me what sizes are allowed for each type of cake and color. The correct way to do this is to build validation lists of each cake type, flavor/color, size to make data entry easy and exact. As for a Calendar or DTPicker control, that is harder. It is doable but you need to change settings or references in your VBA editor.

ALSO - you should have given me the exact format you want, now that I've shown you Pivot Tables. Then you should explain exactly what you require as an output in the Pivot.

If you do this yourself, you'd see you can start keeping costs and profit by cake type or color or size by adding columns to the data.

ALSO - I put in the number of cakes, in case you wanted to make 2 or 5 or 10 of them in a batch. You didn't have this noted in your example.

This seems like one of those "never ending problems" where you will see new and better ways of doing things and want someone else to do it for you as an add-on....