Summing based on criteria
 

I am currently trying to reconfigure a dataset into something more
managable for our regression needs. The issue I am having is trying to
automate as much of the data transfer as possible. The data set is set
up as follows (for example):

Yr Tag Value
0 2 #
1 2 #
2 3 #
3 3 #

0 1 #
1 1 #
2 1 #
3 1 #

etc. where tag is a special code we have developed based on the number
1, 2, 3, and 4

What I would like to do is develop a summing formula so in year 0 I can
sum all the values if the tag is equal to 1 and then I would do that for
the numbers 1 through 4 in my "compilation" worksheet.

Thanks for any help you can give,

Josh


--
jspizman
------------------------------------------------------------------------
jspizman's Profile: http://www.excelforum.com/member.php...o&userid=30694
View this thread: http://www.excelforum.com/showthread...hreadid=563340

Summing based on criteria
 

=sumproduct(--(A1:A1000=year),--(B1:B1000=tag),C1:C1000)

change the years and tags as appropriate



"jspizman" wrote:


I am currently trying to reconfigure a dataset into something more
managable for our regression needs. The issue I am having is trying to
automate as much of the data transfer as possible. The data set is set
up as follows (for example):

Yr Tag Value
0 2 #
1 2 #
2 3 #
3 3 #

0 1 #
1 1 #
2 1 #
3 1 #

etc. where tag is a special code we have developed based on the number
1, 2, 3, and 4

What I would like to do is develop a summing formula so in year 0 I can
sum all the values if the tag is equal to 1 and then I would do that for
the numbers 1 through 4 in my "compilation" worksheet.

Thanks for any help you can give,

Josh


--
jspizman
------------------------------------------------------------------------
jspizman's Profile: http://www.excelforum.com/member.php...o&userid=30694
View this thread: http://www.excelforum.com/showthread...hreadid=563340