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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

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,696
Messages
5,573,684
Members
412,548
Latest member
wallisonlac
Top