ExcelBanter - How do I sum all in a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I sum all in a column (https://www.excelbanter.com/excel-discussion-misc-queries/186099-how-do-i-sum-all-column.html)

Mike

How do I sum all in a column

How do I sum or get a count of all in a column of mixed words - say count all
in column d that are equal to "Fire" If column d had 100 and fire was 10 how
do I get the 10 count?
Thank you

Gary''s Student

How do I sum all in a column

=COUNTIF(A:A,"Fire")
--
Gary''s Student - gsnu200783

All times are GMT +1. The time now is 12:22 AM.