Sumif on multi sheets

[mooredb]

I am trying to figure out how to add sumif on all the different sheets if they match a certain t-shirt. I need to count all the smalls, large, x-large etc. on each sheet of the sizes and color on the master sheet.

https://1drv.ms/x/s!AsTgNTf7crASzn9MB3Jgc7H8QUZC

Any help would be GREATLY appreciated!

thank you so much.
Darren

 

[Jeffrey Mahoney]

Just use a formula that uses more than one COUNTIF:
=COUNTIF(Sheet1!$D4:$D200,"Large")+COUNTIF(Sheet2!$D4:$D200,"Large")

 

[mooredb]

Thanks Jeffery - I am sorry I don't think I explained my self well. What I am trying to do is add up all the smalls from each sheet that match Charcoal. I need to get a sum of all the smalls in charcoal from all the sheets.

Would the countif formula still work? I can't seem to make that work.

Thank you.

 

[Jeffrey Mahoney]

Use the COUNTIFS function
Multiple criteria. Same principal.

 

[sandy666]

is that what you want?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#70AD47]

Shirts​

[/td][td=bgcolor:#70AD47]

SM​

[/td][td=bgcolor:#70AD47]

MD​

[/td][td=bgcolor:#70AD47]

LG​

[/td][td=bgcolor:#70AD47]

XL​

[/td][td=bgcolor:#70AD47]

2XL​

[/td][td=bgcolor:#70AD47]

3XL​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Black Long Sleeve[/td][td=bgcolor:#E2EFDA]

9​

[/td][td=bgcolor:#E2EFDA]

22​

[/td][td=bgcolor:#E2EFDA]

16​

[/td][td=bgcolor:#E2EFDA]

14​

[/td][td=bgcolor:#E2EFDA]

3​

[/td][td=bgcolor:#E2EFDA]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Charcoal / CVC 6210 NL[/td][td]

43​

[/td][td]

123​

[/td][td]

120​

[/td][td]

144​

[/td][td]

34​

[/td][td]

4​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Dark Navy / CVC 6210 NL[/td][td=bgcolor:#E2EFDA]

2​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA]

7​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

1​

[/td][td=bgcolor:#E2EFDA]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Heather Gray / 3600 NL[/td][td]

10​

[/td][td]

22​

[/td][td]

19​

[/td][td]

35​

[/td][td]

13​

[/td][td]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Military Green / 3600 NL[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

16​

[/td][td=bgcolor:#E2EFDA]

29​

[/td][td=bgcolor:#E2EFDA]

30​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Military Green / CVC 6210 NL[/td][td]

86​

[/td][td]

165​

[/td][td]

161​

[/td][td]

200​

[/td][td]

64​

[/td][td]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]Navy / Women's V-Neck[/td][td=bgcolor:#E2EFDA]

8​

[/td][td=bgcolor:#E2EFDA]

22​

[/td][td=bgcolor:#E2EFDA]

20​

[/td][td=bgcolor:#E2EFDA]

22​

[/td][td=bgcolor:#E2EFDA]

10​

[/td][td=bgcolor:#E2EFDA]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Royal Blue / CVC 6210 NL[/td][td]

63​

[/td][td]

121​

[/td][td]

157​

[/td][td]

180​

[/td][td]

40​

[/td][td]

0​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E2EFDA]White / 3600 NL[/td][td=bgcolor:#E2EFDA]

15​

[/td][td=bgcolor:#E2EFDA]

30​

[/td][td=bgcolor:#E2EFDA]

46​

[/td][td=bgcolor:#E2EFDA]

50​

[/td][td=bgcolor:#E2EFDA]

15​

[/td][td=bgcolor:#E2EFDA]

0​

[/td][/tr]
[/table]

I assume that there are quantities on each sheet
and there are duplicates also