On Mon, 2004-11-15 at 05:20, David O'Brien wrote:
Hi group
I need to count the occurrences of pairs of data in a spreadsheet. e.g.
Col A Col B Red Yes Red No Green No Green No Blue Yes Blue No
I need to count the number of rows where both Red and Yes occur, both Green and Yes occur and both Blue and Yes occur. These are individual counts that will appear in different cells on another sheet. In this case, the solution is: Red 1 Green 0 Blue 1
I think http://www.openoffice.org/servlets/ReadMsg?list=users&msgId=795557 offers a way to do what you want. Check it out and also http://www.openoffice.org/servlets/ReadMsg?list=users&msgNo=75848 Couldn't the COUNTIF function be used here? Not sure though how to get
G. Roderick Singleton wrote: the function to only count either 'yes' or 'no'. -- The COUNTIF Little Helper ======================================================================== Hylton Conacher - Linux user # 229959 at http://counter.li.org Currently using SuSE 9.0 Professional with KDE 3.1 Licenced Windows user ========================================================================