Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Somebody pls help me!!

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Hong Kong
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    A B C
    1 Full Planned 150
    2 Full Actual 148
    3 Part Planned 50
    4 Part Actual 39
    5 Full Planned 150
    6 Full Actual 162

    How can I have the sum of "Full" "Actual" that equals 310?

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Assuming that the numbers are in column A and "Full", etc...are in column B, enter the following formula in the formula bar and press ctrl-shift-enter (same time):

    Code:
    =SUM((B1:B6="Full")*(C1:C6="Actual")*D1:D6)
    Hope this helps.


  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,426
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    Edited (information in 2 columns)

    310 =SUMPRODUCT((A1:A6="Full")*(B1:B6="Actual")*(C1:C6))
    310 =SUMPRODUCT((A1:A6=F1)*(B1:B6=G1)*(C1:C6))




    look at Sumif in Help

    310 =SUMIF(B1:B6,"Full Actual",C1:C6)

    with criteria in E1
    310 =SUMIF(B1:B6,E1,C1:C6)


    Revise cell references as necessary

    [ This Message was edited by: Dave Patton on 2002-05-01 09:31 ]

  4. #4
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If 1 & Full are in the same cell use the following in the formula bar:

    Code:
    =SUM((MID(A1:A6,3,4)="Full")*(B1:B6="Actual")*C1:C6)
    And press ctrl-shift-enter at the same time.

    _________________
    Cheers, NateO

    [ This Message was edited by: NateO on 2002-05-01 09:44 ]

  5. #5
    New Member
    Join Date
    Apr 2002
    Location
    Hong Kong
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank You guys!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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