SUM Problem

[firstWeMeet]

Hi,
I put a formula for V3 cell which is =SUM(D3:U3), the cell from D3 to U3 some are not containing numbers its a date like 7/3/2011 and the rest is number like 1.00,100.00 and etc, then I just get wrong answer for my formula, can anyone fix this? thanks

 

[Richard Schollar]

Dates in Excel are held as numeric values which I presume is causing you the problem as they are being added in to your sum? The obvious solution is not to include the date cells in your sum. Alternatively, if you can use a second adjacent range to determine which cells you sum (eg D2:U2) then you could use a SUMIF instead. For example, if you had a Y in D2:U2 of the cells in row 3 you wanted to sum you could use:

=SUMIF(D2:U2,"Y",D3:U3)

 

[firstWeMeet]

Hi Mr Richard, so there is no other formula to fix it without making anychanges on my form?