CountIf using non-adjacent cells as a range

hnetel

New Member
Joined
Nov 22, 2005
Messages
4
I am trying to use a CountIf statement where the range in which I am counting consists of cells that are not adjacent. I could do this with a named range, but this is in a case where I want to be able to copy the formala to a bunch of different cells without having to create many named ranges ......... any help would be appreciated.
 

hnetel

New Member
Joined
Nov 22, 2005
Messages
4
For example I want to count the number of times I get the word "Pass" in cells A1,C1,E1,G1 ........ all odd columns.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,121
hnetel said:
For example I want to count the number of times I get the word "Pass" in cells A1,C1,E1,G1 ........ all odd columns.
=SUMPRODUCT(--(MOD(COLUMN(A1:G1)-COLUMN(A1)+0,2)=0),--(A1:G1="Pass"))
 

hnetel

New Member
Joined
Nov 22, 2005
Messages
4
Wow you guys are amazing! Thanks!

Quick question, what is the "--" do?

Thanks.
 

Forum statistics

Threads
1,078,400
Messages
5,339,991
Members
399,346
Latest member
t0land

Some videos you may like

This Week's Hot Topics

Top