getting #value! instead of total

[Patcheen]

when i paste this i get #value!

=SUM(IF('Shirt Database'!A2:A500,'Goal Keeper List'!B61,SUMIF('Shirt Database'!$F$2:$F$500,{"sub on","sub off","started","injured"},'Shirt Database'!$K$2:$K$500)))

TIA

 

[steve the fish]

What are you trying to do there?

 

[FormR]

Hi, looks like it should be:

=SUM(SUMIFS('Shirt Database'!$K$2:$K$500,'Shirt Database'!$F$2:$F$500,{"sub on","sub off","started","injured"},'Shirt Database'!A2:A500,'Goal Keeper List'!B61))

 

[Patcheen]

Hi, looks like it should be:

=SUM(SUMIFS('Shirt Database'!$K$2:$K$500,'Shirt Database'!$F$2:$F$500,{"sub on","sub off","started","injured"},'Shirt Database'!A2:A500,'Goal Keeper List'!B61))

works a treat thank you

 

[steve the fish]

Hi, looks like it should be:

=SUM(SUMIFS('Shirt Database'!$K$2:$K$500,'Shirt Database'!$F$2:$F$500,{"sub on","sub off","started","injured"},'Shirt Database'!A2:A500,'Goal Keeper List'!B61))

I thought that but couldnt seem to understand why you would want to add up those 4 conditions.