SUMProduct formula error

[Taff]

Hi all,

any reason why i would be getting a #Value error using the formula:

=SUMPRODUCT(--(Season=$LU$2),--(home=$LV5),--(FTHomegoals+FTAwaygoals>MV3))

Season Lu2 is referencing the range of the data i wont to use
Home = LV5 is pointing to the particular team & where it would be listed
FTHomegoals is a column with all home goals
FTawaygoals is a column with all away goals
MV3 is a figure i am using as a reference point.

Ideally i want to find out home many times the home team (LV5) has been involved in matches during the season (LU2) and the total goals (FThomegoals+FTAwaygoals) have been more that MV3 (an arbitrator figure i enter manually)

As always appreciate any guidance

Taff

 

[Taff]

apologies, i was misreading the seasons, thanks,

but when i transfer this formula to the larger work book, i still get a #value ! error......

 

[Fluff]

In that case I would suggest that either the ranges are not the same size, or you have text values in one of the goals section

 

[Taff]

thanks for your help, its got something to do with the addition of the goals section of the formula. Have confirmed sizes values etc, but still no joy..

i have put a local work around in place and that is working fine

appreciate the advice given

 

[Fluff]

Glad you've sorted it & thanks for the feedback