deriving a daily/weekly/monthly tally based on values in a range - with or without VBA

[faste]

is there a way to turn this:

(col a)        (col b)           (col c)           (col d)
fruit          frequency eaten    time to eat    red color?
Apple          daily              med             yes
cantaloupe     weekly             high            no
cherry         monthly            low             yes

into this?

monthly count
red/low     red/med     red/high     non-red/low     non-red/med     non-red/high
1           30           0            0              4               0

 

[faste]

I can count 1 value, but not sure how to combine:

=IF(C1:C3="med",(ROWS(C1:C3)))

I think I could figure out the daily/weekly/monthly count part by multiplying by 30 if = "daily", etc. Putting it all together, I'm having a tough time.

 

[faste]

I think I solved the crux of it, I'll figure out the daily/weekly/monthly part later:

=COUNTIFS(C:C, "med",D:D, "yes")

would give me the count of values where "med" and "yes" in columns c and d both exist. Pretty simple actually.