From: tearl42 on 27 Jan 2010 14:21 Greetings to all, I need to sum cell values based on the value of another. Here is the example... A B 1 44.00 \$5,874.40 2 44.00 \$- 3 44.00 \$- 4 23.00 \$516.67 5 44.00 \$557.20 If A1:5 = 44 then sum B & the row in column A that equaled 44... So the total should be \$6431.60 I've been banging my head on this for a while and just can't seem to figure out where I'm going... TIA, Tom From: joemeshuggah on 27 Jan 2010 14:29 =SUMIF(A:A,A1,B:B) or =SUMIF(A:A,44,B:B) if you just need 44 "tearl42" wrote: > Greetings to all, > > I need to sum cell values based on the value of another. Here is the > example... > A B > 1 44.00 \$5,874.40 > 2 44.00 \$- > 3 44.00 \$- > 4 23.00 \$516.67 > 5 44.00 \$557.20 > > If A1:5 = 44 then sum B & the row in column A that equaled 44... > > So the total should be \$6431.60 > > I've been banging my head on this for a while and just can't seem to figure > out where I'm going... > > TIA, > > Tom >  |  Pages: 1 Prev: Inserting sheets into Excel workbookNext: cannot open excel file from outlook