473,406 Members | 2,769 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

problem in the excel programming in countif

vivekgs2007
I am using the count if statement in programing..i got the problem in displaying the result..
Expand|Select|Wrap|Line Numbers
  1. =COUNTIF(G7:AI7,">13:30")
i want to display the calculated result in Ak5..but it is not coming...lease help me that...
May 5 '10 #1

✓ answered by NeoPa

I think you're simply missing the Date/Time literals. Try :
Expand|Select|Wrap|Line Numbers
  1. =COUNTIF(G7:AI7,">#13:30#")

3 1790
NeoPa
32,556 Expert Mod 16PB
I think you're simply missing the Date/Time literals. Try :
Expand|Select|Wrap|Line Numbers
  1. =COUNTIF(G7:AI7,">#13:30#")
May 5 '10 #2
ok i get the answer the problem is in the format cells..thank you very much for your concern...
May 5 '10 #3
NeoPa
32,556 Expert Mod 16PB
A pleasure to help :)
May 5 '10 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Bartje | last post by:
Hey, I am wondering what the best solution will be to program the following problem in access, the dutch 97 edition. I am developing a database for a day care centre (for my girlfriend). This...
2
by: Jet | last post by:
Hi all, I have written a com+ component by c#,and when I register it into com service it thorw me a warmming mean "There isn't interface of this class in class testCom.objCom,so it can't use...
2
by: Avik | last post by:
hi, Can anybody tell me that how i could modify an excel file resided in my web server without using excel automation on my server side code. is there any other alternative like third party...
1
by: lanem | last post by:
I am trying to create an excel spreadsheet from my asp.net(vb.net) page. I can do this, but I just cannot find much documentation or code samples online. There is some for very common tasks, but...
3
by: drgonzo120 | last post by:
hello, A buddy of me made a modification on a TB-303 synthesizer (made in 1982) so it is possible to program the synth via a parallel port connector. He made a program in qbasic and he wants a...
1
by: mpltkvx | last post by:
Hello, This is a question regarding MS-Access programming. 1. Network environment: I got a room with 50 people answering the phone and logging the topics of the incoming calls. Each has a PC,...
2
by: Finger.Octopus | last post by:
Hi .. I'm a newbie to python win32 programming. I was just reading Python Programming on Win32 and I was trying to run this program: # SimpleCOMServer.py - A sample COM server - almost as...
2
by: Simit Kulkarni | last post by:
HI Everybody, I just joined the C# developer community. And hope u all C# gurus will help me to solve my problem. OK ! Problem is this, I am using Microsoft.Office.Interop.Excel; ...
6
by: grego9 | last post by:
I am trying to write some code to get Excel 2000 to insert a blank row wherever there is a "NO" in column O (above the NO). The code below nearly does this - but not quite!. The problem I have is...
0
by: Dhananjay | last post by:
hi all, I am facing problem in programming.Can anybody please let me know how to solve the problem. I have a link, clicking the link opens a page in which there are some data which is coming from...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.