Show Specific Category by day and how many times

[apollopt]

Hi,

After a few hours seeing some posts i cant really find a way to solve my problem.

What i need help from is the following (see exemple file in attach):

I need to know how many types of food (specific ) there is by day.

For exemple: On day 15 i have 17 times Tomato. (the real file have hundereds of lines)

The final goal is to make a weekly chart to know how many times per day appear "Tomato"

[contaminated]

hIapollopt
Take a look at this sample
i ended up with this formula

=SUM((($F6=INT($A$2:$A$46))*(G$5=$D$2:$D$46))*1)
confirmed w/ Ctrl+shift+Enter

[apollopt]

hIapollopt
Take a look at this sample
i ended up with this formula

=SUM((($F6=INT($A$2:$A$46))*(G$5=$D$2:$D$46))*1)
confirmed w/ Ctrl+shift+Enter

Hi Again,
And thx for the help. But theres something i cant understand..
I treied to add 3 more Lines with a different name and make the formula and its not working...
Can you please check the formula and see what im doing wrong?

[contaminated]

Because Couves entry in column D has gap, whereas Couves entry in J% has no gap at the end.
In short "Coves " <> "Coves"

You can solve this issue if you eliminate gap after all words or add just TRIM function to do this. Eg you can use thius formulae also...

=SUM((($F6=INT($A$2:$A$49))*(G$5=TRIM($D$2:$D$49)))*1)

Confirmed w/ ctrl+shift + enter and copied down then accross
HTH

[arthurbr]

Why invent the wheel again?

XL provides Pivot Tables to suit your needs ( see attached)

The only thing you will have to cope with is the increasing list.
To do this use Dynamic Ranges for which there is an explanation here