SUM with a twist

[Nell1017]

Hi All -

I want to be able to sum a variety of rows within my dataset. But rather than summing the entire column, I want to be able to sum based on certain criteria in another column. I have 400+ rows of data, so I would prefer not to SUM "manually" to get the dollar figures that I want.

So, I have a number of rows in my dataset with unique IDs, such as -- 1, 1.1, 1.2, 1.3, 1.5, 2, 2.1, 10, 11, 11.1, 34.3, 34.7, etc. and various dollar amounts are tied to each of these rows. I want to be able to sum all of the rows that start with 1 together - 1.1, 1.2, 1.3, 1.5. All of the ones that start with 2 together and so on.

Is there any way to automatically group them together and make this happen? I am at a loss , any help would be appreciated!

 

[Matty]

Better options, Nell1017:

njimack:

=IF(A2=INT(A2),SUM(IF(INT($A$2:$A$12)=A2,$B$2:$B$12)),"")

HOTPEPPER:

=IF(A2=INT(A2),SUMPRODUCT(--(INT($A$2:$A$12)=A2),$B$2:$B$12),"")

Less function calls than what I suggested (I don't know why I didn't think of this approach ).

Matty

 

[Nell1017]

Thanks so much everyone!

Looks like I am just not good at following directions. I was hitting Control+Alt+Enter, and it took me a few times to realize what I was doing wrong.

Thanks again for all your help!