Search Date

[Gresens]

I have the following formula that I am trying to use on a
table to sum the product of a table if 2 conditions
hold. However, I am hitting a stumbling block on the
first condition (which was previously taken from a
successful that returned true if the company name desired
was a match), which I want to be true if the cell
reference has a date in the desired year (i.e., if the
cell has 2/8/2001, I want it to return true when I am
summing things for the year 2001 and false for the other
years).

Can somebody help?

Thanks

=SUMPRODUCT(--((ISNUMBER(SEARCH(2001,Equity!$B$2:$B$162)))
*(ISNUMBER(SEARCH("Education",Equity!
$C$2:$C$162)))),Equity!$L$2:$L$162)

Note that the problem occurs where I currently have
2001. Thanks

 

[Frank Kabel]

Hi
try:
=SUMPRODUCT(--(YEAR(Equity!$B$2:$B$162)=2001)
*(ISNUMBER(SEARCH("Education",Equity!
$C$2:$C$162)))),Equity!$L$2:$L$162)