G Gary''s Student Dec 29, 2009 #2 Say A1 thru B7 contain: cat 1 cat 2 hat 3 hat 4 bat 5 cat 6 rat 7 in D1 put: cat and then =SUMIF(A1:A7,D1,B1:B7) correctly displays 9
Say A1 thru B7 contain: cat 1 cat 2 hat 3 hat 4 bat 5 cat 6 rat 7 in D1 put: cat and then =SUMIF(A1:A7,D1,B1:B7) correctly displays 9
P Pete_UK Dec 29, 2009 #3 Yes. It would be handy if you gave some details, but you could have something like this: =SUMIF(A:A,">"&C1,B:B) This will add up the values in column B where column A values are greater than the item in C1. Hope this helps. Pete
Yes. It would be handy if you gave some details, but you could have something like this: =SUMIF(A:A,">"&C1,B:B) This will add up the values in column B where column A values are greater than the item in C1. Hope this helps. Pete
