Question: 3. Use DSUM To summarize mailing daTa. a. On The Ma'lings sheet noTe ThaT number senT is locaTed in The Third column and response daTa

3. Use DSUM To summarize mailing daTa. a. On The Ma'lings sheet noTe ThaT number senT is locaTed in The Third column and response daTa is in The TourTh column. b. Click The CIiTeria sheeT Tab. SelecT cell I32 and Type Ian* To selecT daTa for The Landscape Design deparTment Click The Mailing Slais sheeT Tab and selecT cell I57. Use DSUM WiTh The range name Responses as The DaTabase argument Type 3 for The Field argument and use an absoluTe reference To cells 51:32 on The Crii'ea sheeT as The CriTerr'a argument e. Copy The formula To cell C? and ediT The Field argumenT To use The TourTh column. T. CompleTe crileria for The Two remaining deparTmenTs on The CIiTea sheeT. g. Click The Mailing Slais sheeT Tab and selecT cell BB. h. Use DSUM in cells 38:09 To calculate resulTs for The Two deparTmenTs. 9-9
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
