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

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
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,112,883
Messages
5,543,019
Members
410,583
Latest member
gazz57
Top