Search results for query: *

Hi Skip, thanks for the solution that worked great! I was also playing around and found that the COUNTIFS function worked as well. =COUNTIFS(Sheet1!B2:B5,1,Sheet1!C2:C5,"ABC*") Sorry about the crystal confusion, I have it as my signature as I usually post in the crystal forum. Thanks again...

Hi Skip, Ya trying to do this in Excel 2010, is it still relevant in this forum? Also, sorry forgot to mention that my data is in another Sheet. Thanks, Steve Running Crystal 11 - 14.0.2.364

Hello, I'm trying to Count a range of cells (ex: Col C) that starts with "ABC" if it's in a certain month or date range (Col B) I have a helper column for the dates, so if Col A is = January 5, then Col B = 1, Col A = February 13, then Col B = 2 etc. Sample Data would look like this: Col...

Hi pmax, You're solution worked great! I did finally figure out a way to do it but my way involved creating a formula for each transaction description saying if txn descrip='DR' then 1 which I basically created 8 times, 4 for count and 4 for dollar values. Then created another formula that...

Hi there, I have a Cross-Tab set up that has a list of store location #'s by row and then a list of accounts across the columns. It is totaling up the number of transactions by count and $sum of each each store # to each account The count/sum of transactions fields are made up of 4 txn types...

OMG...thanks Andy, I'll just delete this post now lol. Running Crystal 11 - 14.0.2.364

Hi Skip, Wondering if you could help with this formatting situation as well. If I have a whole number value, is there a way to format it so the last two digits are the cents? ie., 1614500, I need this to read as $16,145.00 and not $1,614,500.00. Also, the number value can range from 1 digit...

Hi Skip, Thank you for the quick response, worked great! Running Crystal 11 - 14.0.2.364

Hi There, I'm trying to create a formula that will look at a cell value then run that value against a list and return the description of the corresponding value. I think this has to do with a look up function. Ex: My main worksheet is sheet 1, and I would like the column P to take the value...

Aghh running totals that would help! Forgot about that haven't used Crystal in a while little rusty. Thanks Pmaxx! Running Crystal 11 - 14.0.2.364

Hi there, I'm trying to create 4 different columns that would show me the Count records and Sum of the dollar values between specific $dollar ranges. Ex: record 1 = $10.25 record 2 = $30.00 record 3 = $0.21 record 4 = $55.00 record 5 = $101.00 I need to create 4 different dollar ranges...

Actually that seems a lot cleaner and simpler. Thanks for that! Running Crystal 11 - 14.0.2.364

That worked! That's going to become real handy. Thanks Skip! Running Crystal 11 - 14.0.2.364

Yep Running Crystal 11 - 14.0.2.364

Keeps giving me an error that that says 'value is not available to the formula or function' Changed the formula to this "=INDEX(sheetB!A:A,MATCH(B1,sheetB!B:B,0),1)" but returns #N/A. Running Crystal 11 - 14.0.2.364

Hi Skip, I couldn't quite get it, it's probably because I have the rows and columns not correctly identified in the formula but I made a quick example that will hopefully clarify it better in case the formula isn't what I'm trying to achieve. In Sheet 1: A1=(blank) B1=123 A2=(blank) B2=456...

Thanks for the reply judgeh59. Would you know how to write this? If not, hopefully Skip V will come to the rescue! Should also not that I'm using excel 2010. Thanks. bnsSteve. Running Crystal 11 - 14.0.2.364

Hello, Wondering if its possible to create a formula that will take a cell in one sheet and reference a column in another sheet then return a value in that row if the cells match. For example: In Sheet A - cell A1 will take the value in B2 then check all the values in Column A in Sheet B to...

Thanks LB works great! Was originally resetting on change of field. Running Crystal 11 - 14.0.2.364

Hi there, Sorry this has been posted a lot, couldn't find one that I could use as a template. Need to sum up $value on only one record which are duplicated. Ex: Group1 - (Transit) ABC Group2 - (App#) 123 Detail (App#)123 - (Transit) ABC - $1,000 (App#)123 - (Transit) ABC - $1,000 (App#)123...