Summing cell values based on the value of another
in [General]
|
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 workbook Next: cannot open excel file from outlook |