Creating a formula

J

Jupiter53132

i have a long list of data with 10 columns of information, one column
identifies my committee that's responsible (the committees are identified
numerically 1 to 9), I have another column with sub units that roll up to
specific committees, sometimes i have one sub unit to one committee, other
times i have 4 sub units to 1 committee. how can i create a formula that
answers this question: countif[committee column, "1"]and [filed column, "no"]
seems simple enough to me but i can't make it work
 

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

Creating a Chart on form from selected data in query. 0
List all tables, including document structure 0
Mail Merge Skips Some Records 1
Cumulative formula for word table 0
Count frequence in one column 1
Convert old wordbasic code into VBA that will run now 0
A lookup with a difference 3
Macro to Select text from a point given to a specific word 2

Top