please help...
how to set the formula to count the no. of times of each person buying Food or Misc in 2006 or 2007? Thanks
Year Name Food/Misc No. of Times
2007 Peter F 12
2006 Tom F 15
2007 Ann M 15
2007 Peter F 16
2006 Peter M 3
2007 Tom F 2
2006 Ann M 1
2007 Peter M 17
2006 Ann M 18
how to set the formula to count the no. of times of each person buying Food or Misc in 2006 or 2007? Thanks
Year Name Food/Misc No. of Times
2007 Peter F 12
2006 Tom F 15
2007 Ann M 15
2007 Peter F 16
2006 Peter M 3
2007 Tom F 2
2006 Ann M 1
2007 Peter M 17
2006 Ann M 18