sumif function


August 6th, 2013 by Tiffany johnson Tiffany johnson

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)

One Response to “sumif function”

  1. BenneTan BenneTan Says:

    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

You must be logged in to post a comment.

s2Member®