I did not mean the *all* literally.

Not tested:

Function SumScreened(dateCell As Long, range1 as range, range2 as range) As Double
SumScreened = WorksheetFunction.SumIf(range1, dateCell, range2)
End Function

And of course call it like

=sumscreened(A1,A2:A1001,C2:C1001)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"I need help please" wrote in message
...
| Thanks Niek!!!
| Sorry for not knowing, but how would I include the *all* worksheet data?
|
| Function SumScreened(dateCell As Long) As Double
| Dim range1 As Range
| Dim range2 As Range
| Set range1 = Worksheets("Individual").Range("A2:A1001")
| Set range2 = Worksheets("Individual").Range("C2:C1001")
|
| SumScreened = WorksheetFunction.SumIf(range1, dateCell, range2)
| End Function
|
|
| that is one of my most simple functions. Where would I put the *all*?
|
| Function SumScreened(dateCell As Long) As Double *all*
| or
| Function SumScreened(dateCell As Long *all*) As Double
| or what?
|
|
| Thanks!!!
| "Niek Otten" wrote:
|
| You should include *all* worksheet data used inside the function in the argument list. That is the only way Excel knows the
| dependencies and will recalculate if and when necessary.
|
| You can also include Application.Volatile in your function, but then it will always recalculate with any workbook recalc, even
if
| it is not necessary.
|
| Including all data in the argument list really is the best solution.
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "I need help please" wrote in message
| ...
| |I have many user defined functions. Mostly they count cells based off of
| | MANY MANY criteria. The problem is, once data has been updated, many times
| | the user defined function will not update. If I manually go into the cell
| | that calls it, delete some text & re-type it, it will call the function
| | again, and the data is recalculated. But, I have TONS of cells that I need
| | to do this on. I tried using the refresh data button from the data tab - but
| | that only works on imported data. Is there any way to cause excel to
| | recalculate all of the user defined functions on a particual worksheet or the
| | entire workbook?
|
|
|