Search:

Type: Posts; User: sneaky911; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    5
    Views
    218

    Re: Sum using right or left function

    Need help with one more thing. I've modified your formula a bit. It works as expected with one exception...I need to include something that will avoid throwing an error if there's a blank cell in...
  2. Replies
    5
    Views
    218

    Re: Sum using right or left function

    Works perfectly! Thank you both.
  3. Replies
    5
    Views
    218

    Sum using right or left function

    I have a simple attendance tracking spreadsheet. Data validation is set up to select the "violation" from a list. The violation also has a point total attached to it. Example: Call off 1.0, Early out...
  4. Replies
    6
    Views
    162

    Re: Transpose and repeat formula or script

    Thank you once again!
  5. Replies
    6
    Views
    162

    Re: Transpose and repeat formula or script

    I apologize but how do I alter this for exactly 3 entries before a change?
  6. Replies
    6
    Views
    162

    Re: Transpose and repeat formula or script

    I apologize but how do I alter this for exactly 3 entries before a change?
  7. Replies
    6
    Views
    162

    Re: Transpose and repeat formula or script

    This worked perfectly! Appreciate your help.
  8. Replies
    6
    Views
    162

    Transpose and repeat formula or script

    I have the following data and need a formula or script that will transpose at each change in location. I have several thousand cells in column A to search through. My data is not consistently every...
  9. Re: Macro to insert blank rows below data based on value of specific cell

    Sounds good. Thanks everyone for your help.
  10. Re: Macro to insert blank rows below data based on value of specific cell

    This is exactly what I was looking for. Worked perfectly. Appreciate the help!
  11. Macro to insert blank rows below data based on value of specific cell

    First of all I'd like to apologize. I've seen a few threads addressing my issue but I'm unfamiliar with code and cannot figure out how to modify it to fit my specific data. I have 5 columns of data....
  12. Re: subtotal a range of data if there's a value in a cell in another coulmn

    That's the one! I originally started with the =sumifs but decided to take the long approach when I couldn't get it to work as expected. This is perfect. Appreciate your help!
  13. Re: subtotal a range of data if there's a value in a cell in another coulmn

    Sorry...I probably worded this funny. I'm looking to return 3611 in B6. The expense actually populates from another tab in the file. 3611= Total cases for week 1-3 but not the 885 from week 4....
  14. Re: subtotal a range of data if there's a value in a cell in another coulmn

    That one gives me a different result. Would I copy and paste exactly?
  15. Re: subtotal a range of data if there's a value in a cell in another coulmn

    =sum(if(c9<>"",b2:b8,0))+sum(if(c17<>"",b10:b16,0))+sum(if(c25<>"",b18:b24,0))+sum(if(c33<>"",b26:b32,0))
  16. Re: subtotal a range of data if there's a value in a cell in another coulmn

    never mind! solved my own problem.
  17. subtotal a range of data if there's a value in a cell in another coulmn

    <tbody>
    I'm looking to get the Month End totals for week to date but only if there is a value in the Expense field (column 3) In the example provided I would like the Month End row to only calculate...
Results 1 to 17 of 17