Thread: Help from excel wiz please ...
View Single Post
Old 02-06-2005, 08:54   #3
gazzae
Inactive
 
gazzae's Avatar
 
Join Date: Jun 2003
Location: Belfast
Age: 46
Posts: 4,594
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
gazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronzegazzae is cast in bronze
Re: Help from excel wiz please ...
As bmxbandit says use SUMIF.

Say if the critera is in column A rows 1-6 and the data is in column B rows1-6 then the sumif to total all the X's would be this....

=SUMIF(A1:A6,"X",B1:B6)
gazzae is offline   Reply With Quote