Re: [libreoffice-users] Spreadsheet Formula Query

2015-09-02 Thread Gordon Burgess-Parker
On 02/09/15 11:59, John Montgomery wrote: Hi Folks I have attached a file called "Spreadsheet Query". This list doesn't accept attachments. You need to upload it to a file-sharing site and post the link -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Spreadsheet Formula Query

2015-09-02 Thread John Montgomery
Hi Folks I have attached a file called "Spreadsheet Query". It is part of a much larger file but the contents will suffice for my question. What should the formula for "K2" be? The formula for L2 is (=COUNTIF($G$2:$G$750,J2)". You will see that Column "L" counts the number of individuals assigned