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
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,830
Office Version
  1. 365
Platform
  1. Windows
Just use a formula that uses more than one COUNTIF:
=COUNTIF(Sheet1!$D4:$D200,"Large")+COUNTIF(Sheet2!$D4:$D200,"Large")
 

mooredb

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

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,499
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,411
Messages
5,595,985
Members
414,035
Latest member
billbumkins

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
Top