Ian Harris

Posts: n/a

If statement help needed

Hi
How can I set this function to look for and count the letter L as well as H

=IF(A8="","",COUNTIF(F8:AJ8,"H"))

Regards
Ian

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF Statement with Average Function results in #Value!	Paul	Excel Discussion (Misc queries)	5	December 28th 04 08:11 AM
If statement help needed please	Ian Harris	Excel Discussion (Misc queries)	3	December 3rd 04 11:37 AM
Statement	lintan	Excel Worksheet Functions	1	December 2nd 04 11:31 PM
If statement needed	Patsy	Excel Worksheet Functions	1	November 4th 04 03:48 PM
IF Statement difficulty	susan hayes	Excel Worksheet Functions	3	November 2nd 04 09:46 PM

All times are GMT +1. The time now is 06:59 PM.

About Us

"It's about Microsoft Excel"