| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MEDIAN, STDEV of a range IF another range = specific value
In article ,
Barb Reinhardt wrote: This does what I want, thanks. You're welcome! Glad I could help! How do I copy it over a bunch of cells? If you're copying the formula down the column... =MEDIAN(IF(D$2:D$107=D111,F$2:Q$107)) If you're copying the formula across the row... =MEDIAN(IF($D2:$D107=D111,$F2:$Q107)) DO I have to confirm each and every one? No, you only need to confirm with CONTROL+SHIFT+ENTER for the first cell, then you can copy or drag the formula down or across... Hope this helps! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting specific row/column from a named range | Excel Worksheet Functions | |||
| How to sum data that is only within a specific number range? | Excel Worksheet Functions | |||
| How do I add a range of numbers to sum a specific total? | Excel Worksheet Functions | |||
| Displaying value of specific cell within a range, with IF function...? | Excel Discussion (Misc queries) | |||
| find numbers in a range that add to a specific value | Excel Discussion (Misc queries) | |||
Threaded Mode
