ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   looking up for subtotals stretched criteria to count visible cells (https://www.excelbanter.com/excel-discussion-misc-queries/197446-looking-up-subtotals-stretched-criteria-count-visible-cells.html)

driller

looking up for subtotals stretched criteria to count visible cells
 
First of all, i hope this is easy.

Is it possible *?* to have a subtotal() formula in a column that can count
the cells like;

Formula 1) count the visible cells in a column which start with a text "C".

Formula 2) count the visible cells in a column which start with a text "C" &
next number(s) is 2 or more. (e.g. if cell contains text like "C1df",
subtotal will not count, if the cell contains text like "C2dfg" or "C10jky"
or "C6KL", then subtotal will consider to count this.).

Please try to help me on the above subject.

--
regards,



All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com