ExcelBanter - exclude data from count

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - exclude data from count (https://www.excelbanter.com/excel-worksheet-functions/46100-exclude-data-count.html)

wdama13

exclude data from count

I am doing a count of information in rows. I want to show certain
information in these rows, but don't want to count it in the total. What can
I do?

Bernie Deitrick

Variations or combinations of SUMPRODUCT or COUNTIF would like do it, but an example, an
explanation, and an expected result would help us help.

HTH,
Bernie
MS Excel MVP

"wdama13" wrote in message
...
I am doing a count of information in rows. I want to show certain
information in these rows, but don't want to count it in the total. What can
I do?

All times are GMT +1. The time now is 03:56 AM.