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
Bookmarks