I have 2 columns one is date & the other is text - I need a formula to tell
me how many times each text appears on each date

I thought =Sumproduct((A1:A200="date")*(B1:B200="Text")) would work. The
even more complicated bit is the "date" bit is in a cell to enable it to be
copied down