PDA

View Full Version : Solved: Count Formula Based Currency Criteria



naris
10-13-2009, 01:51 AM
I need a formula which I can count the value in range depend specific currency creteria.
Please, help me to solve it.
for the detail, please see the attachment enclosed.

Thanks in the advance.

Bob Phillips
10-13-2009, 03:05 AM
Use a UDF to do it



Function SumCcy(rng As Range, ccy As String) As Double
Dim cell As Range

For Each cell In rng

If cell.Text Like "*" & ccy & "*" Then

SumCcy = SumCcy + cell.Value2
End If
Next cell

End Function

naris
10-13-2009, 05:57 PM
Dear James Thurber,

You have my thanks, you have solve my problem.

Regards,
Naris

Aussiebear
10-13-2009, 08:10 PM
Dear James Thurber,

LOL..... Actually James Thurber provided the quote, but XLD assisted you with the solution.