Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Ian Harris
 
Posts: n/a
Default If statement help needed please

Hi
How can I get the following function to check and count for the letter L as
well H

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

Regards
Ian


  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Ian

check out your original post in microsoft.public.excel.worksheet.functions
it's generally not necessary to post to more than one group as most people
read most of the groups.

Cheers
JulieD

"Ian Harris" wrote in message
. ..
Hi
How can I get the following function to check and count for the letter L
as well H

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

Regards
Ian



  #3   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

Don't multipost! (My ansver is in NG
microsoft.public.excel.worksheet.functions)


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Ian Harris" wrote in message
. ..
Hi
How can I get the following function to check and count for the letter L

as
well H

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

Regards
Ian




  #4   Report Post  
Ian Harris
 
Posts: n/a
Default

Hi
I am sorry please forgive a first time poster
no offense was intended
Regards
Ian
"Arvi Laanemets" wrote in message
...
Hi

Don't multipost! (My ansver is in NG
microsoft.public.excel.worksheet.functions)


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Ian Harris" wrote in message
. ..
Hi
How can I get the following function to check and count for the letter L

as
well H

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

Regards
Ian






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Macro and If Statement SATB Excel Discussion (Misc queries) 2 December 3rd 04 04:46 PM
Autofit in excel - cell is large than what is needed or wanted & . seezzell Excel Discussion (Misc queries) 2 December 3rd 04 06:39 AM
If statement in VBA Jeff Excel Discussion (Misc queries) 1 December 2nd 04 09:35 PM
=IF statement Dick Excel Discussion (Misc queries) 10 November 27th 04 02:47 PM
The "Open" statement carl0s66 Excel Discussion (Misc queries) 1 November 26th 04 04:26 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"