SUMIF with dates

[Jay Platt]

I am trying to subtotal a sales column by years. I have
tried the following formula:

=SUMIF((F2:F200),Year(F2:200)=P2,H2:H200))

where F is my date column (formatted mm/dd/yy), P is just
a label column containing 1983, 1984, etc. and H is the
column of sales I want summed. Can someone tell me what
I'm doing wrong? I keep getting 0 as my sum.

 

[Frank Kabel]

Hi Jay
one way
=SUMPRODUCT((YEAR(F2:F200)=P2)*(H2:H200))

HTH
Frank

 

[Laurie]

=SUMIF((F2:F200),P2,H2:H200))

 

[Frank Kabel]

Hi Laurie
I think this won't work as column F is a date and column P just
contains a (year) number. So this will result in a '0' (IMHO)

Frank

 

[Jay Platt]

That's what I was looking for. Thanks a lot.

-----Original Message-----
Hi Jay
one way
=SUMPRODUCT((YEAR(F2:F200)=P2)*(H2:H200))

HTH
Frank




.

 

[Frank Kabel]

Hi Jay
thanks for the thanks
Frank