Sumif on multi sheets

mooredb

New Member
Joined
Jan 5, 2011
Messages
32
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
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Just use a formula that uses more than one COUNTIF:
=COUNTIF(Sheet1!$D4:$D200,"Large")+COUNTIF(Sheet2!$D4:$D200,"Large")
 
Upvote 0
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.
 
Upvote 0
is that what you want?

Shirts
SM
MD
LG
XL
2XL
3XL
Black Long Sleeve
9​
22​
16​
14​
3​
0​
Charcoal / CVC 6210 NL
43​
123​
120​
144​
34​
4​
Dark Navy / CVC 6210 NL
2​
7​
7​
10​
1​
0​
Heather Gray / 3600 NL
10​
22​
19​
35​
13​
0​
Military Green / 3600 NL
10​
16​
29​
30​
10​
0​
Military Green / CVC 6210 NL
86​
165​
161​
200​
64​
2​
Navy / Women's V-Neck
8​
22​
20​
22​
10​
0​
Royal Blue / CVC 6210 NL
63​
121​
157​
180​
40​
0​
White / 3600 NL
15​
30​
46​
50​
15​
0​

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

Forum statistics

Threads
1,213,489
Messages
6,113,949
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top