Posts by hahsj

  • countifs with specific name between two dates

    Hello!


    Hoping to get some help, my excel skills are not what they used to be but think i came to the right place!


    I have attached a sample data sheet which will help explain what I am trying to do. I'd like to count the number of times a name appears in the data set between two specific dates.


    For the first name (bob) - On the "Summary" Tab, I want to count the number of times his name appears in the "Data Tab" in column I between the dates 8/3/2019 and 8/30/2019 - the dates are in column D.


    I'm assuming I'd use the countifs function, but had a few issues. Please let me know if I can provide additional information!

  • If Statement with nested and/or (calculations)

    Hi NBVC,


    Thanks a lot, I was definitely doing this incorrectly haha.


    Could you shed some light on the lookup function if possible and the use of the "{" "}", It is something I am not super familiar with (the vector portion).


    Would there be anyway to run this function using and/or and avoid the lookup? Is using vlookup an option too? or lookup is the only way?


    Thanks again!

  • If Statement with nested and/or (calculations)

    Hello all! (first post)


    Have a question about writing a formula to capture a business scenario that requires calculations to be different depending on how many units are sold. I thought I had the model down, but when I tried to input all the numbers it did not work! note - this is not for a work situation this is just something I came across in a course. Thanks in advance!
    [TABLE="border: 1, cellpadding: 1, width: 500"]

    [tr]


    [td]

    units (conditions)

    [/td]


    [td]

    if condition met, then display or do following

    [/td]


    [/tr]


    [tr]


    [td]

    Less Than 80,000

    [/td]


    [td]

    N/A

    [/td]


    [/tr]


    [tr]


    [td]

    80000

    [/td]


    [td]

    2,800,000

    [/td]


    [/tr]


    [tr]


    [td]

    80,001-90,000

    [/td]


    [td]

    multiply # of units by $35

    [/td]


    [/tr]


    [tr]


    [td]

    90,001-100,000

    [/td]


    [td]

    multiply # of units by $45

    [/td]


    [/tr]


    [tr]


    [td]

    Above 100,001

    [/td]


    [td]

    multiply # of units by $55

    [/td]


    [/tr]


    [/TABLE]


    I will give a few values to use.just need some help generating the formula so this is more or less automated


    99642
    243989
    114597
    125887
    88000
    92000


    Please let me know if more information is needed and can go from there. Thanks!