How do you find out the number of occurences of a category between two dates?

[cclondon]

Hi Forum experts,

Grateful if you could tell me the formula that I need to use to calculate, e.g. the number of people who have eaten an apple (other options -apple, orange and peach) between 18th August 2019 to 2nd October? The results then appear in a table on a separate worksheet.

So there is 1 column labelled fruit, with the different fruit written in text. Then there is another column labelled date with the various dates that each person ate the fruit. So I need to find out how many people ate the 3 pieces of fruit within the time period.

Best wishes

Claudine

[davsth]

=countifs(fruitrange,"Apple",daterange, ">="&43695,daterange, "<="&43740)


if fruits are a1:A100, dates are b1:b100 and c1 contains 18 Aug 19 (as a date) and c2 contains 2 Oct 19 as a date, and c3 contains apple
=countifs(a1:a100,c3,b1:b100,">="&c1,b1:b100,"<="&c2)