Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Nov 2012
    Posts
    5
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Help with Excel formula

    I am working on a large spreadsheet that I cannot figure out the formulas for.

    I am trying to set formulas for orders that have been placed for individuals each month and have the speadsheet configure totals of responses that came in from those mailings for each month for each state.

    Column C are the months the orders were placed
    Column J are the states for where these orders were placed
    Column P are the responses that came in from these mailings

    Can someone please help me with this???????

    Thank you,
    Tina

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,486
    Thanks
    211
    Thanked 850 Times in 782 Posts
    Tina,

    Welcome to the Lounge as a new poster.

    It would be very helpful if you could post a sample workbook with made up data on one sheet and the data and expected results (manually calculated) on a second sheet. It is hard to tell just what you want from the description above.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    DPMarketing (2012-11-19)

  4. #3
    New Lounger
    Join Date
    Nov 2012
    Posts
    5
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Good Morning RG,

    Thank you for the warm welcome!

    I've attached my file.

    Thank you,
    Tina
    Attached Files Attached Files

  5. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 341 Times in 334 Posts
    For the number of replies in Nov from CA you can use a formula like:
    =SUMPRODUCT(($C$2:$C$26="Nov")*($J$2:$J$26="CA")*$ P$2:$P$26)

    Adjust the ranges as desired. Also instead of the explicit text in the formula, you could refer to a cell if desired.

    A Pivot Table could give the results as well.

    Steve

  6. The Following User Says Thank You to sdckapr For This Useful Post:

    JohnS0603 (2012-11-22)

  7. #5
    New Lounger
    Join Date
    Nov 2012
    Posts
    5
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Good Morning Steve,

    Oh my gosh...............THANK YOU!!!!!!

    Now, I have another question. What if I wanted to have my formulas on Sheet 2? I know how to do the sumif function, but this is now far beyond me.

    Thank you,
    Tina

  8. #6
    New Lounger
    Join Date
    Nov 2012
    Posts
    5
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi Steve,

    Oh my gosh................Never mind, I got it and figured it out.

    Thank you so very much!

    Tina

  9. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 341 Times in 334 Posts
    You could use sumifS:
    =SUMIFS(Sheet1!$P$2:$P$26,Sheet1!$C$2:$C$26,"Nov", Sheet1!$J$2:$J$26,"CA")

    if that is more clear than SUMPRODUCT [I often revert to formulas that are pre-XL2010 as I have been using them since XL97 before some of the newer formulas]

    Steve

  10. The Following 2 Users Say Thank You to sdckapr For This Useful Post:

    DPMarketing (2012-11-19),JohnS0603 (2012-11-22)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •