Thanks everyone

So, I have a column of dates that are formatted and showing ex:2008 when
formatted by date however, if I look at the same date fields formatted as
"normal" I see 39538


I am trying to get a sum of all paid part numbers by year
(2007,2008,2009,2010) which is this

=SUMIF(A8:M23,K24,L8:L23)

A8: M23 is the entire table
K24 - 27 are the date variable (2007,2008,2009,2010)
L8 - L23 are the prices
A 8 - A 23 are the dates columns

Basically in this table, show me the sum of part numbers purchased for each
year.

Hope you can help
--
Neall


"Mike H" wrote:

Hi,

Dates in Excel are numbers - format one as general to see that - and we only
see them as dates because of the applied formatting.

The problem your experiencing arises because in a formula that format can be
lost and has the be added back by formatting the formula cell as a date or
using the TEXT function.

If you post the problematic formula then someone will help you sort it out.

Mike

"Neall" wrote:

I have been racking my brain to figure out why my formula is not working but
now I see that when reviewing the results through the functional argument
tool I see that excel is reading the day (march 31 2010) as 39538.

On the spreadsheet it clearly shows me the correct date format but when
excel is reading the formula it is not.

Can someone help?

Thanks
--
Neall