what is the formula please??

P

p3project

If a8:a1000 contains dates and f8:f1000 contains an X if the item i
over due, can you tell me the formula to show a running total of X tha
have a 2004 value in column A on Sheet 2 please.

Any help would be most welcome.

Many thanks

Dav
 
K

Kieran

Dave,

use the following array-entered (use ctrl-shft-enter not enter whe
entering the formula)

=SUM((YEAR(A8:A1000)=2004)*(UPPER(F8:F1000)="X"))

or use this formula just normally entered.

=SUMPRODUCT(INT(YEAR(A8:A1000)=2004),INT(UPPER(F8:F1000)="X")
 
J

JE McGimpsey

If I understand you correctly:

=SUMPRODUCT(--(YEAR(Sheet1!A8:A1000)=2004),--(Sheet1!B8:B1000="X"))
 
Top