Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merging Cells but have each cell counted in the range of merged c.
I'm trying to figure out a formula that will count each cell in a range of
merged cells as having the same text as the 1st cell in the range. |
#2
|
|||
|
|||
Hi
try something like =COUNTIF(A2:A20,A1) -- Regards Frank Kabel Frankfurt, Germany "gats13" schrieb im Newsbeitrag ... I'm trying to figure out a formula that will count each cell in a range of merged cells as having the same text as the 1st cell in the range. |
#3
|
|||
|
|||
Gats,
You would need to use a user-defined-function, given below. Copy and paste the code into a codemodule, and use it like =mySum(A1:D4) HTH, Bernie MS Excel MVP Function mySum(inRange As Range) As Double Dim myCell As Range Dim myMC As Range For Each myCell In inRange For Each myMC In myCell.MergeArea mySum = mySum + myMC.Value Next myMC Next myCell End Function "gats13" wrote in message ... I'm trying to figure out a formula that will count each cell in a range of merged cells as having the same text as the 1st cell in the range. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Auto fit merged cells | Excel Discussion (Misc queries) | |||
How do you delete one cell from a range of protected cells | Excel Worksheet Functions |