Hey there,
I could really use a hand with something here.
Here’s what my spreadsheet looks like:
Column A Column B Column C
03/14/2008 1949001 25
03/14/2008 1949001 50
03/14/2008 1949001 75
03/14/2008 1949002 25
03/14/2008 1949002 50
03/15/2008 1949001 50
03/15/2008 1949001 50
So, what I'm looking for is a function that can sum up all the weights whenever the date and the ID match up. My Microsoft Excel file is massive—we're talking over 200,000 rows of data here—so it needs to be efficient. For example, if I look at ID 1949001 for the date 03/14/2008, the total should come out to 150.
Thx
I could really use a hand with something here.
Here’s what my spreadsheet looks like:
Column A Column B Column C
03/14/2008 1949001 25
03/14/2008 1949001 50
03/14/2008 1949001 75
03/14/2008 1949002 25
03/14/2008 1949002 50
03/15/2008 1949001 50
03/15/2008 1949001 50
So, what I'm looking for is a function that can sum up all the weights whenever the date and the ID match up. My Microsoft Excel file is massive—we're talking over 200,000 rows of data here—so it needs to be efficient. For example, if I look at ID 1949001 for the date 03/14/2008, the total should come out to 150.
Thx