Counta with If

reaktorblue

Board Regular
Joined
Aug 8, 2007
Messages
76
For whatever reason, I'm drawing blanks on this one. I'm currently using =COUNTA(tblCourses[Name]) to count the number of courses I have. I had to add a column to my table, tblCourses[State] and I intend to type "Inactive" if the course is no longer available.

How could I modify the counta formula to only counta when tblCourses[State] is blank?
 
Last edited:

reaktorblue

Board Regular
Joined
Aug 8, 2007
Messages
76
Thanks,

Yes that does work but I ended up settling on =COUNTIFS(tblCourses[Name],"<>",tblCourses[State],"<>Inactive") since by default, the State column would be blank. Only the courses with an inactive state are what I want to omit from counting. Thanks again!
 

Forum statistics

Threads
1,085,844
Messages
5,386,303
Members
401,992
Latest member
CleverHopper

Some videos you may like

This Week's Hot Topics

Top