Countif help

bakerman

Board Regular
Joined
Sep 9, 2005
Messages
188
I am using count if to look at a table containing letters ( no problems )
The countif i'm using looks in a block of 4 cells and returns the answer. In the next cell i want to to enter another count if formula that looks in the same row but misses out four colloums eg
A1=COUNTIF(BN34:BQ34,"L")
B1=COUNTIF(BV34:BY34,"L")

What I'm looking for is an easy way to get excel to create the formulas if I drag a cell across a sheet rather than me having to type each formula in seperatly
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,873
Hi bakerman

In A1 try:

=COUNTIF(OFFSET($BN$34,0,8*(COLUMN()-COLUMN($A$1)),1,4),"L")
copy to right

Hope this helps
PGC
 

Watch MrExcel Video

Forum statistics

Threads
1,118,295
Messages
5,571,388
Members
412,386
Latest member
Yasaman
Top