Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if cell contains a formula
How cant I add a collum of data but only cells with a formula in.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if cell contains a formula
=SUMPRODUCT(--IsFormula(A1:A100))
and add this UDF '--------------------------------------------------------------------- Function IsFormula(rng As Range) As Variant '--------------------------------------------------------------------- Dim cell As Range, row As Range Dim i As Long, j As Long Dim aryFormulae As Variant If rng.Areas.Count 1 Then aryFormulae = CVErr(xlErrValue) Exit Function End If If rng.Cells.Count = 1 Then aryFormulae = rng Else aryFormulae = rng.Value i = 0 For Each row In rng.Rows i = i + 1 j = 0 For Each cell In row.Cells j = j + 1 aryFormulae(i, j) = cell.HasFormula Next cell Next row End If IsFormula = aryFormulae End Function -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "jimtodd" wrote in message ... How cant I add a collum of data but only cells with a formula in. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions |