If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a formula
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 -- Thanks, Susan |
#2
|
|||
|
|||
Creating a formula
=SUMPRODUCT(--(Committee_column=1),--(filed_column="no"))
"Jupiter53132" wrote: 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 -- Thanks, Susan |
Thread Tools | |
Display Modes | |
|
|