LinkBack URL
About LinkBacks
count the merged cells and treat as 1 if the value in is same, for column J5:J798 - let say some of the cell has a value of "B" and some of the are merged (2, 3, 4 or more rows) i need to count as 1 if merged.
count the merged cells and treat as 1 if the value in is same, for column J5:J798 - let say some of the cell has a value of "B" and some of the are merged (2, 3, 4 or more rows) i need to count as 1 if merged.
Use Countif Function
Formula:
Please Login or Register to view this content.
The range J791:J795 has been merged and marked with the text A.
So countif will get the result as 1.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
but how about those blank / empty cell with also with merge need also to count?
use the column K5:k795 to count the blank / empty cells with some of them have merged
To get the count of used cells in a range
Formula:Please Login or Register to view this content.
To get the count of cells in a row
Formula:Please Login or Register to view this content.
To get the count of blank cells in a range
Formula:Please Login or Register to view this content.
Thanks, but try to filter column K with Blanks and when scroll you may find some with text, how to count only the exact rows (not merge rows) + merged rows (this is counted as 1 only even if merged for more than 1 rows [2,3,4,5 or more rows])
That is why we never suggest merged cells
any possible vba for this
Yes using vba we can... Can I offer you UDF?
yes, i need it to finish my report, thanks in advance
Try this UDF...
Please Login or Register to view this content.Please Login or Register to view this content.
Thanks, i will try, question the UDF is counting for merged rows?
It will count all the cells of the merged range.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks