Formula to Check Column A for date range and count Column B

**realniceguy5000** · 10-28-2009, 12:29 PM

I have a formula that counts if a date range is present. However I need to change it to count another column only if that date range is present.

For example a17 a50000 the user will enter the date of the order. and in column B has the order number. I want the formula to count the order numbers for a data range in column A.

Here is what I have but it is counting the dates in col A not the order numbers in B?

Thanks for the help.

Mike

Please Login or Register  to view this content.

**NBVC** · 10-28-2009, 12:32 PM

Try

=Sumproduct(--($A$17:$A$6001>="1/1/2010"+0),--($A$17:$A$6001<="1/31/2010"+0),--Isnumber($B$17:$B$6001))

or

=Sumproduct(--($A$17:$A$6001>="1/1/2010"+0),--($A$17:$A$6001<="1/31/2010"+0),--($B$17:$B$6001<>""))

**realniceguy5000** · 10-28-2009, 12:41 PM

Originally Posted by NBVC

Try

=Sumproduct(--($A$17:$A$6001>="1/1/2010"+0),--($A$17:$A$6001<="1/31/2010"+0),--Isnumber($B$17:$B$6001))

or

=Sumproduct(--($A$17:$A$6001>="1/1/2010"+0),--($A$17:$A$6001<="1/31/2010"+0),--($B$17:$B$6001<>""))

Thanks For the help...

Both formula's seem to work.

I would have edited my other post but it was closed before I could change the heading and got another ticket.

Thanks Again your always a great help!!!!

Mike

**NBVC** · 10-28-2009, 12:58 PM

You are welcome,

Pease remember to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save