in terms of the sumif funtion, that will actually work great for my
purposes.
Now would there also be a way to extend that funtion to a large amount
of sheets? I have sheets that start with 01, and can go all the way to
99. so would anyone happen to know a line i can add to
"=SUMIF(M:M,"Sill",I:I)" to add up all the sheets?
Thanks!


--
foxgguy2005
------------------------------------------------------------------------
foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663
View this thread: http://www.excelforum.com/showthread...hreadid=379939