| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Creating a nested COUNTIF????
Hi all, im trying to get my spreadsheet to count in one cell if certain criteria appear in two other cells, say for instance =COUNTIF(Name,"Bloggs J" and Hours,= number) where hours is the next named range and the number would be from -11 to 11. So in short i would like the value for "Hours" displayed in Bloggs J cell (which could be lets say E3) only if Bloggs J appears in the named range "Name" Hope that is clear and hope you can help! Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=401673 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested Countif | Excel Worksheet Functions | |||
| COUNTIF and Nested Functions? | Excel Worksheet Functions | |||
| Countif Function -Nested | Excel Discussion (Misc queries) | |||
| Creating an EXCEL COUNTIF formula for a range of values | Excel Discussion (Misc queries) | |||
| Countif - Countif | Excel Worksheet Functions | |||
Threaded Mode
