|
| 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
April 23rd, 2010, 09:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
April 23rd, 2010, 11:11 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
