Sum a dataset with 2 criteria
 

Attached is my example.

I want to have a summary sheet that sums (for multiple worksheets) one
column labled "char" only when another column has the same Div No. So
I want my summary sheet to include a list of char summed, but divided
by div (as the char nos. between div are the same). Thanks!


+-------------------------------------------------------------------+
|Filename: trial.txt |
|Download: http://www.excelforum.com/attachment.php?postid=3737 |
+-------------------------------------------------------------------+

--
ineedhelp2
------------------------------------------------------------------------
ineedhelp2's Profile: http://www.excelforum.com/member.php...o&userid=26298
View this thread: http://www.excelforum.com/showthread...hreadid=398763