Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I think I used to know how to do this, but I'm on a new version of Excel
(Xl2003) so maybe that wouldn't work anyway. I want to perform a simple COUNTIF, except the cells I want the function to examine are not contiguous. Essentially, I need the function to be something like the following: COUNTIF((C1,E1,H1,J1,N1),"=1") However that, and other variations I've tried, don't seem to work. This has got to be possible, but I think I need a pointer here. Thanks in advance. -- Hmm...they have the Internet on COMPUTERS now! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
countif >0, specific cells | Excel Worksheet Functions | |||
Order of selecting unprotected cells | Excel Discussion (Misc queries) | |||
Select Range of Cells | Excel Discussion (Misc queries) | |||
How do I use countif across non-adjacent cells? | Excel Worksheet Functions | |||
Fill cells from non-adjacent cells | Excel Discussion (Misc queries) |