Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple rows of data based on criteria | Excel Worksheet Functions | |||
caluculate an average based on 2 criteria | Excel Discussion (Misc queries) | |||
Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
returning a value based on mulitple criteria | Excel Worksheet Functions | |||
Formula to determine a future date based on criteria | Excel Worksheet Functions |