Need the formula for the following How many TVs were sold by Billy? What is the sales total using the store card? Excel.

Store Card N Y Y N. N Transaction ID# Dept 103180 Cameras 391615 TV 424445 TV 321265 Computers 25795 Phones 447895 Appliances 337680 Music 316575 Music 480725 Appliances 541695 Computers 227465 Cameras 504175 Cameras 213395 TV 548730 TV 553350 Phones 440045 Music 437410 Phones 374170 Appliances Salesperson Micky Jiggy Billy Jiggy Billy Kimmy Kimmy Micky Jiggy Billy Jiggy Kimmy Micky Micky Jiggy Jiggy Kimmy Billy N N Amount 416.79 2145.89 679.36 912.99 45.56 231.67 38.99 43.78 128.99 . 499.99 255.67 . 667.23 455.8 1677.77 87.69 32.15 112.16 512.49 Y N N Y N N