Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel Help: Totals per Option from Dropdown box

Nov 15, 2010 4:55AM PST

Hello,

I have departments listed in a drop down box on an expense report. Can I have the spreadsheet automatically calculate the total per department somehow?

Each line gives the option for the department via a dropdown. I'd like those totals to be added at the bottom of the sheet to show the total to allocate per department.

Thanks!!!

Discussion is locked

- Collapse -
Re: Excel
Nov 15, 2010 5:04AM PST

My solution would be a pivot table, I think. But I've also used DBSUM for exactly such a task.

It's not basic use of Excel. Consider it intermediate. Surely not advanced.

Kees

- Collapse -
Great!
Nov 15, 2010 7:13AM PST

Can you give me more info on how to do this? Thanks.

- Collapse -
Re: more info
Nov 15, 2010 4:34PM PST

About pivot tables or about the DBSUM-function?

Kees

- Collapse -
Re:
Nov 16, 2010 2:59AM PST

Whichever you recommend. I don't know anything about either option. Thanks.

- Collapse -
(NT) What version of Excel? 2010, 2007, 2003, 2002? Or Mac?
Nov 16, 2010 4:46AM PST
- Collapse -
2007
Nov 16, 2010 5:20AM PST

thanks Happy

- Collapse -
Re: pivot tables and functions
Nov 17, 2010 3:38PM PST