I have to do a excel sheet that needs a formula that looks at a date in one
column and everytime that date appears in the one column go to another column
and count the amount of times it is there.

example in column c there is todays date. in column g there is info. what
is the simplest way to count what is in column g i the date is in column c.

--
Message posted via http://www.officekb.com

=countif(c1,g:g)

--
Regards,
Fred


"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:71fcf2b5d616e@uwe...
I have to do a excel sheet that needs a formula that looks at a date in one
column and everytime that date appears in the one column go to another column
and count the amount of times it is there.

example in column c there is todays date. in column g there is info. what
is the simplest way to count what is in column g i the date is in column c.

--
Message posted via http://www.officekb.com

tried that it is coming back as 0

Fred Smith wrote:
=countif(c1,g:g)

I have to do a excel sheet that needs a formula that looks at a date in one
column and everytime that date appears in the one column go to another column
and count the amount of times it is there.

example in column c there is todays date. in column g there is info. what
is the simplest way to count what is in column g i the date is in column c.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200705/1

See if this works:

=SUMPRODUCT(--(C1:C100=TODAY()),--(G1:G100<""))

This counts the number of times that today's date appears in Column C and
the corresponding row in Column G is not blank.

Is that what you're looking for? If not, it may help if you provide more
specific examples of what you want.

HTH,
Elkar


"Darrell_Sarrasin via OfficeKB.com" wrote:

tried that it is coming back as 0

Fred Smith wrote:
=countif(c1,g:g)

I have to do a excel sheet that needs a formula that looks at a date in one
column and everytime that date appears in the one column go to another column
and count the amount of times it is there.

example in column c there is todays date. in column g there is info. what
is the simplest way to count what is in column g i the date is in column c.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200705/1

that worked perfectly thank you. I ran a sumproduct on it earlier but I did
not think of using the :not blank theory. Thanks again.

Elkar wrote:
See if this works:

=SUMPRODUCT(--(C1:C100=TODAY()),--(G1:G100<""))

This counts the number of times that today's date appears in Column C and
the corresponding row in Column G is not blank.

Is that what you're looking for? If not, it may help if you provide more
specific examples of what you want.

HTH,
Elkar

tried that it is coming back as 0

[quoted text clipped - 6 lines]
example in column c there is todays date. in column g there is info. what
is the simplest way to count what is in column g i the date is in column c.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200705/1

Fred may have intended to say =countif(g:g,c1) ?
--
David Biddulph

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:71fd3c1d61199@uwe...
tried that it is coming back as 0

Fred Smith wrote:
=countif(c1,g:g)

I have to do a excel sheet that needs a formula that looks at a date in
one
column and everytime that date appears in the one column go to another
column
and count the amount of times it is there.

example in column c there is todays date. in column g there is info.
what
is the simplest way to count what is in column g i the date is in column
c.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200705/1

You're right. I guess my dyslexia is not in complete remission :)

Fred.

--
Regards,
Fred


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Fred may have intended to say =countif(g:g,c1) ?
--
David Biddulph

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:71fd3c1d61199@uwe...
tried that it is coming back as 0

Fred Smith wrote:
=countif(c1,g:g)

I have to do a excel sheet that needs a formula that looks at a date in one
column and everytime that date appears in the one column go to another
column
and count the amount of times it is there.

example in column c there is todays date. in column g there is info. what
is the simplest way to count what is in column g i the date is in column c.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200705/1