# single criteria

1. ### Sum across muiltiple sheets only when crieria met

Hello all, I've tried if, sumif, sumproduct, indirect etc and cannot find a way to do this i hope someone can help me. My Summary sheet contains a cell with the following formula =SUM(Abe:Wyn!I7) (where Abe:Wyn = 218 worksheets and identically formatted) This has worked well but now I need...
2. ### Array formula to list all People with certain eye color returning blank cells.

Hey everyone, It seems to me that I am getting strange output of an excel formula and for the life of me I can't figure out why. Could someone explain why I am getting these results? The goal of this array formula is to list all the first names of the people with a certain eye color. In this...
3. ### VLOOKUP over multiple sheets

What I am trying to do is take a certain SKU, then return the text located in the 18th column associated with the SKU. The search for the SKU is over around 30 different worksheets with around 200 to 4000 lines on each sheet. SKUs will be repeated many times throughout, but this column should...
4. ### Median based on criteria of another cell

{=MEDIAN(IF('textexport(2)'!J:J>0,'textexport(2)'!F:F))} I keep receiving 0 when using this formula. I want to take the median of values in column F if the corresponding values in colum J are above 0. Any ideas why this does not work.
5. ### Select unique concatenated valued based on a crititerion

I have data in excel that looks like the below…there are additional columns but for this question I will use the abbreviate one below <TABLE style="MARGIN: auto auto auto 4.65pt; WIDTH: 345.15pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0in 5.4pt 0in 5.4pt"...

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### 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?

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