"Neall" wrote:
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.

I presume you mean you want the sum of the prices.

=sumproduct((year(A8:A23)=K24)*(L8:L23))


----- original message -----

"Neall" wrote in message
...
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