|
Count the occurence of more than one condition
Got this function from Excel Help but it gives me #Value error. Can anyone help? =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0))) Number of invoices for Buchanan with a value less than 9,000. (1) -- wutang1105 ------------------------------------------------------------------------ wutang1105's Profile: http://www.excelforum.com/member.php...o&userid=26683 View this thread: http://www.excelforum.com/showthread...hreadid=399547 |
It is an array formula, so after typing it, hit Ctrl-Shift-Enter together,
not just Enter. -- HTH RP (remove nothere from the email address if mailing direct) "wutang1105" wrote in message ... Got this function from Excel Help but it gives me #Value error. Can anyone help? =SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0))) Number of invoices for Buchanan with a value less than 9,000. (1) -- wutang1105 ------------------------------------------------------------------------ wutang1105's Profile: http://www.excelforum.com/member.php...o&userid=26683 View this thread: http://www.excelforum.com/showthread...hreadid=399547 |
| All times are GMT +1. The time now is 02:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com