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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.