Autosum

Topic

New Reply

I’m putting X’s in all of the rows where the corresponding names of guests have been invited to an event. Is it possible to do an Autosum at the very bottom row that adds up the total number of people who received an X?

Regards,

JMT

Reply | Quote

Replies

I guess the function COUNTIF(range, criteria) will do the trick:
=COUNTIF(A1:A175,”X”)

Note that “X” counts both “X” and “x” cells

Reply | Quote

Is there a way to do it so that Excel will count all of the cells in a given column that have any number written therein?

Reply | Quote

In such case, the function COUNT(range) is your friend! It returns from the specified range the number of numeric values.

Two other useful functions: COUNTBLANK(range) will count the number of empty cells. COUNTA(range) will count the number of cells with a content.

Reply | Quote