Silly question

  • Thread starter Darrell_Sarrasin via OfficeKB.com
  • Start date
D

Darrell_Sarrasin via OfficeKB.com

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.
 
E

Elkar

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
 
D

Darrell_Sarrasin via OfficeKB.com

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.
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
Click to expand...
[quoted text clipped - 6 lines]
Click to expand...
 
F

Fred Smith

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

Fred.

--
Regards,
Fred


David Biddulph said:
Fred may have intended to say =countif(g:g,c1) ?
Click to expand...
 
Top