Counting the Number of Open Projects In a Week

Copper Contributor

I need help generating a formula and really wish Excel would support Week numbers better. Anyway here's what I'm trying to do:

countif ("closed YYWW" = 0) && ("created YYWW" >= "current YYWW")

 

Or in English: return the total number of projects that are open in a specific week to populate a pivot table. 

 

It seems super easy but I cant seem to figure out how to do a sum/total with an AND argument plus YYWW isn't a supported data format from what I can tell.

1 Reply

Hi @BC_Diver , could you please send a sample of your file? (you can populate it with fake data)

 

With this, will be easier to we find a solution together.