General sumif functionAugust 6, 20131Comments 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 August 6, 2013 Hi Tiffany. would you mind sending us a sample data containing the problem you face? firstname.lastname@example.org 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 Log in to Reply Leave a Reply Cancel ReplyYou must be logged in to post a comment.