Excel 2003 Sum question?

[STG2Mustang]

have a group of columns that use a formula to pull data from another sheet. An example of my formula is below.

=IF(AND('SS7 Numbers'!A8=1,'SS7 Numbers'!B8=1,'SS7 Numbers'!N8="CHUCK"),"1","0")

When information is entered on the mane sheet the formula above will place a “1” or a “0” in my cell on another Excel page. I then go to the bottom of the new sheet and try to sum the column and no mater how many “1” are in the column the sum will only give the answer of “0”. I am using =SUM(B2:B9). If I take the same cells and go B2+B3+B4+B5+B6+B7+B8+B9 and enter it will give me the correct answer. Is there a way to tell Excel to Sum the value (B2:B9) to get the correct answer?

The spreadsheet I am going to make will have more that 9 rows and would be very hard to get the sum to work using (B3+B4+B5+B6+B7+B8+B9)

Thanks

Chuck

[VBA Noob]

Hi,

Just remove the "" from around the 1 and 0. The "" makes excel think it is text.

=IF(AND('SS7 Numbers'!A8=1,'SS7 Numbers'!B8=1,'SS7 Numbers'!N8="CHUCK"),"1","0")

VBA Noob