EXCEL SUMIF & AVERAGEIF HELP! Need help crearting these functions!

In cell D33, create a function to Sum the Cost Price by Genre and Category. (SUMIF only, do not use SUMIFS)

a. Copy it down to cell D41 4.

In cell E33, create a function to Average the Cost Price by Genre and Category. (AVERAGEIF only, do not use AVERAGEIFS)

a. Copy it down to cell E41

Home Insert Draw Page Layout Formulas Data Review View Share Calibri Wrap Text Delete Merge & Center. $ v% , S8 Conditional Format Cell conditional Formale Styles FormaSart Format. V ? Formating as Table E38 Vantage Video Rentals W-1032 The Bridige an the River K 25/08 K Videos Adv FunctionsLookup No No Yes No Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No Yes No Yes No No Yes No 2B at