Hi,
I have a column of values in "£"s and i need to count how many entries there are within a range. I have been able to do it with text but not money values with £ signs!!
any ideas...
Dan
Hi,
I have a column of values in "£"s and i need to count how many entries there are within a range. I have been able to do it with text but not money values with £ signs!!
any ideas...
Dan
Last edited by NBVC; 11-12-2008 at 11:05 AM.
Do you mean COUNT(range) ?
Where range: A1:A10 etc...
Or by range do you mean count values with a specific range of values ?
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Oops - was using COUNTIF instead of COUNT - it now works!!
Thanks for the prompting!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks