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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!