Solved Add a sum to a drop down list

May 20, 2020 at 01:08:27
Specs: Windows
How do you have a sum entered to a cell in a drop down list.
Eg: I pick an item from the drop down list. At the end of the column I want to tally total no records, How do I go about with it?

See More: Add a sum to a drop down list

Reply ↓  Report •

#1
May 20, 2020 at 06:16:22
✔ Best Answer
I want to tally total no records

Try one of the COUNT functions:

COUNT() "Counts the number of cells that contain numbers"
COUNTA() "Counts the number of non-empty cells"
COUNTBLANK() "Counts the number of blank cells in the range."
COUNTIF() & COUNTIFS() "Counts the number of cells that meet the criteria specified in the argument"

and for future reference, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •
Related Solutions


Ask Question