Countif and then some...

J

Julie

hello - I would GREATLY appreciate anyones help here.

I am doing a countif(range, "=AB") however I want to in the next column do
the same countif(range, "=AB") and then countif(newrange, ">07/01/2005)

I'm tryiing to count ab's in one column and then in the second count I need
to say ok out of the ab's I counted in the first formula how many are
07/01/2005)
Click to expand...

Thank you again for anyones tips\formulas!!!! Julie
 
D

Duke Carey

You'll need to use a sumproduct()

=SUMPRODUCT(--(range="AB"),--(newrange>DATE(2005,7,1)))
 
J

Julie

Hi Duke! Thanks so much for you response...

It was a great help - what if I need to do a date range instead say between
7/1/05 and 7/29/05? how would i put that in the formula?
 
D

Duke Carey

Julie -

You can just add one more condition to the formula:

=SUMPRODUCT(--(range="AB"),--(newrange>DATE(2005,7,1)),--(newrange<DATE(2005,7,29)))
 
J

Julie

Hi Duke thank you again!

for some reason this isn't calculating for me..
SUMPRODUCT(--(Sheet2!E2:E77="SK"),--(Sheet2!H2:H77>=DATE(2005,7,1)),--(Sheet2!H2:H77<=DATE(2005,7,29)))

it gives me back a 0 where it should be returning 1
 
Top