missing parenthesis help

[desert rat]

Apologies for the many posts recently but have been dumped with putting a report together asap.


Think i have been staring at this one for too long and can't work out whats missing. Any help would be great appreciated.


=SUMPRODUCT((--(($C$2:$C$236="Male")*(($S$2:$S$236<=94)),SUBTOTAL(103,OFFSET(S2,ROW(S2:S236)-ROW(S2),0))


Apparently i'm missing a parenthesis somewhere.........


Thanks

 

[NARAYANK991]

Hi ,


=SUMPRODUCT(--(($C$2:$C$236="Male")*($S$2:$S$236<=94)),SUBTOTAL(103,OFFSET(S2,ROW(S2:S236)-ROW(S2),0)))


Narayan

 

[desert rat]

Thanks again Narayan you've been a massive help!