Using sumproduct to count number by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the sumproduct function to count how many times a
particular date appears in a coumn and I cannot get it to work. The date
format is 6/6/2005. I must be overlooking something but I don't know what.
Anybody got an answer? Thanks
 
If you are counting, then why not use COUNTIF?

Here's an example: =COUNTIF(A1:A8,C1)

where A1:A8 is the range of dates and C1 is the date for which you are
testing.
 
Thanks for your answer. The reason I thought to us SUMPRODUCT is because I'm
looking through multiple columns to find my counts. For example, orders
entered on a certain date, by a certain rep, that have a certain code. All of
these values are in columns. How would you go about formulating that
question?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNT rows on external sheet if between date range 3
sumproduct count with date 4
Sumproduct Help! 2
SUMPRODUCT Function 3
Count between two dates using sumproduct 6
SUMPRODUCT Issue 5
Excel Sumproduct 0
sumproduct 3 criteria inc. date 8

Back
Top