I am trying to sum all travel for three months. It is only giving me one help.

here is the formula
=SUMIF(A4:E97,A4,C4:E98)

    1 Response to "sumif function"

    • BenneTan

      Hi Tiffany. would you mind sending us a sample data containing the problem you face?
      upload@everydayexcel.com
      ideally, key in manually 1 or 2 answers you are expecting to see. Thanks. Theoretically, your range & sum_range should have the same number of rows & columns, but it’s hard to tell what is wrong like that

Leave a Reply