getting #value! instead of total

Patcheen

Active Member
Joined
Sep 28, 2015
Messages
314
Office Version
  1. 365
Platform
  1. Windows
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
 
Last edited:

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,430
Office Version
  1. 365
Platform
  1. Windows
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

Active Member
Joined
Sep 28, 2015
Messages
314
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Oct 20, 2009
Messages
8,111
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,492
Messages
5,529,176
Members
409,854
Latest member
rickcoba
Top