 | | |
| jonlumb wrote: =IF(AND(condition 1,condition 2),Answer if Yes, Answer if No) | |
| | |
Thanks Jon, I kept hunting and found this instead:
=SUMPRODUCT(--($Feuil1.$D$4:$D$1987=818);--($Feuil1.$I$4:$I$1987="Y"))
| x404.co.uk http://www.x404.co.uk/forum/ |
|
| [SOLVED] Excel/Spreadsheet help http://www.x404.co.uk/forum/viewtopic.php?f=3&t=10442 |
Page 1 of 1 |
| Author: | forquare1 [ Wed Sep 08, 2010 12:02 pm ] |
| Post subject: | [SOLVED] Excel/Spreadsheet help |
**Placed here because I'm using OpenOffice on a Mac but my boss is using the same file in Excel on Windows, thus it doesn't really fit into PC Software, Mac Software, or Open Source** Hi all, I'm trying to do this in a spreadsheet: count = 0; If((a range of cells = 818) AND (another range of cells = Y)){ count++; } I reckon it can be done with something like COUNTIF, SUMIF, or a combination of one of those with AND and IF...But I can't see what it is... Thanks, Ben |
|
| Author: | jonlumb [ Wed Sep 08, 2010 12:07 pm ] |
| Post subject: | Re: Excel/Spreadsheet help |
=IF(AND(condition 1,condition 2),Answer if Yes, Answer if No) |
|
| Author: | forquare1 [ Wed Sep 08, 2010 12:33 pm ] | |||||||||
| Post subject: | Re: Excel/Spreadsheet help | |||||||||
Thanks Jon, I kept hunting and found this instead: =SUMPRODUCT(--($Feuil1.$D$4:$D$1987=818);--($Feuil1.$I$4:$I$1987="Y")) |
||||||||||
| Page 1 of 1 | All times are UTC |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|