Prev: Word lists
Next: Dynamic DropDown list from Unsorted vector
From: Jupiter53132 on 23 Apr 2010 16:48
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
From: Teethless mama on 23 Apr 2010 18:11
=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
 | 
Pages: 1
Prev: Word lists
Next: Dynamic DropDown list from Unsorted vector