Does the COUNTIF criteria parameter accepts functions?

  • Thread starter Thread starter williambbradley
  • Start date Start date
W

williambbradley

I'm trying to use a function (WEEKNUM) as the criteria for a range in
COUNTIF. Is this possible?
 
No you can't, and you cannot even use it in SUMPRODUCT because WEEKNUM will
not handle an array of dates. So you have to craft your own

=SUMPRODUCT(--(1+INT(($A$2:$A$20-(DATE(YEAR($A$2:$A$20),1,2)-WEEKDAY(DATE(YEAR($A$2:$A$20),1,1))))/7)=1))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
See my comment on SP.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



Try with SUMPRODUCT.

Pete
 

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

Excel Need Countifs Formula Help 0
countifs Function not giving desired result with date criteria 2
Excel conditional formatting with Weeknum 4
COUNTIF....how to use >=0 but <9 as CRITERIA 3
Count the number of cells that conatin a "." in a range 5
countif using other cell values for 'range' and 'criteria' 4
Countifs bites again 4
SUMPRODUCT help 3

Back
Top