| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count values in range based on value in same row
To save time adding additional copies of the data to the individual spreadsheet is there a way of combining this formula ?
=IF($e3="Male",Q3,"") for example I have used this 'Master Sheet'!E3="Male", but I realise that as the row changes this reference would not change. Does anyone know how I could amend / replace this formula to give the required result =IF('Master Sheet'!E3="Male",COUNTIF('Master Sheet'!Y3:Y203,"=31")) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count values in range based on value in same row
Add a defined name (InsertNameDefine...) or the current E3 cell and use
that in the formula =IF(Mastefield",COUNTIF('Master Sheet'!Y3:Y203,"=31")) HTH Bob "Mick Bonser - newbold" wrote in message ... To save time adding additional copies of the data to the individual spreadsheet is there a way of combining this formula ? =IF($e3="Male",Q3,"") for example I have used this 'Master Sheet'!E3="Male", but I realise that as the row changes this reference would not change. Does anyone know how I could amend / replace this formula to give the required result =IF('Master Sheet'!E3="Male",COUNTIF('Master Sheet'!Y3:Y203,"=31")) -- Mick Bonser - newbold |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
| Sum values in columns based on values in named range | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Linear Mode
