Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bnsSteve

    Excel CountIf formula

    ...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 for the quick reply! Running...
  2. bnsSteve

    Excel CountIf formula

    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
  3. bnsSteve

    Excel CountIf formula

    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...
  4. bnsSteve

    Cross-Tab Forumla to Count and Sum

    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...
  5. bnsSteve

    Cross-Tab Forumla to Count and Sum

    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...
  6. bnsSteve

    Excel Lookup Function

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

    Excel Lookup Function

    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...
  8. bnsSteve

    Excel Lookup Function

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

    Excel Lookup Function

    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...
  10. bnsSteve

    Count and Sum between dollar ranges

    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
  11. bnsSteve

    Count and Sum between dollar ranges

    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...
  12. bnsSteve

    Cell look up

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

    Cell look up

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

    Cell look up

    Yep Running Crystal 11 - 14.0.2.364
  15. bnsSteve

    Cell look up

    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
  16. bnsSteve

    Cell look up

    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...
  17. bnsSteve

    Cell look up

    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
  18. bnsSteve

    Cell look up

    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...
  19. bnsSteve

    Summing dupped amounts

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

    Summing dupped amounts

    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...

Part and Inventory Search

Back
Top