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

Thread: Sumif

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

    Default

    I have been trying to figure out a formula to
    compare column A to a cell and compare column B to another cell then SUM the value column C
    ex:
    A B C
    DATE Operation tph
    SAT 046-00 8.6
    SUN 046-00 0
    WED 047-00 7.6
    THU 047-00 9.8
    SAT 331-00 44.5

    I tried
    =SUM(IF($A$2:$A$2049=$G2,IF($B$2:$B$2049=$F4,1,0),0)) but this return the count, I need SUM of column C not a count .




  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-23 17:26, AJDionne wrote:
    I have been trying to figure out a formula to
    compare column A to a cell and compare column B to another cell then SUM the value column C
    ex:
    A B C
    DATE Operation tph
    SAT 046-00 8.6
    SUN 046-00 0
    WED 047-00 7.6
    THU 047-00 9.8
    SAT 331-00 44.5

    I tried
    =SUM(IF($A$2:$A$2049=$G2,IF($B$2:$B$2049=$F4,1,0),0)) but this return the count, I need SUM of column C not a count .
    Hi AJDionne:
    You can use the DSUM function:

    =DSUM(A1:C6,"tph",D1:E2) ..... giving the result 7.6

    where the first argument is data_range A1:C6, second argument is tph (the field to be summed, and the third argument is the criteria range with DATE in cell D1, Operation in cell E1, WED in cell D2, and 047-00 in cell E2./

    HTH

    Please post back if it works for you otherwise explain a little further and let us take it from there!



    _________________
    Yogi Anand

    Edit: Deleted inactive website from hardcoded signature

    [ This Message was edited by: Yogi Anand on 2003-01-19 14:02 ]

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
  •