Help Help Help Help!!!
Basically i need to do the following. If i have a list of cells which look like below: £5000 Y £10,000 N £3,000 Y £2,500 N Total £8000 What i want to be able to do is when i change the cell next to the amount (which has the Y or N), i need the total cell at the bootom to add up the only ones which have a Y next to it. Then, later if i was to change it to a N, the total would then subtract that figure, giving the new total PLEASE PLEASE HELP!!!!! -- stapleton2308 ------------------------------------------------------------------------ stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878 View this thread: http://www.excelforum.com/showthread...hreadid=505590 |
Help Help Help Help!!!
Hi Stapleton.
See SUMIF in Excel Help. Try something like: =SUMIF(B1:B7,"=Y",A1:A7) --- Regards, Norman "stapleton2308" wrote in message news:stapleton2308.229rfa_1138324801.3139@excelfor um-nospam.com... Basically i need to do the following. If i have a list of cells which look like below: £5000 Y £10,000 N £3,000 Y £2,500 N Total £8000 What i want to be able to do is when i change the cell next to the amount (which has the Y or N), i need the total cell at the bootom to add up the only ones which have a Y next to it. Then, later if i was to change it to a N, the total would then subtract that figure, giving the new total PLEASE PLEASE HELP!!!!! -- stapleton2308 ------------------------------------------------------------------------ stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878 View this thread: http://www.excelforum.com/showthread...hreadid=505590 |
Help Help Help Help!!!
your a genious!!!!! cheers mate!!! -- stapleton2308 ------------------------------------------------------------------------ stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878 View this thread: http://www.excelforum.com/showthread...hreadid=505590 |
All times are GMT +1. The time now is 12:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com