| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help!!!!!!!!
Basically I have the following data: £2500 COLLECTED 01/03/2006 £3500 NOT COLLECTED 01/02/2006 £4500 COLLECTED 01/03/2006 £3000 COLLECTED 01/03/2006 £3500 NOT COLLECTED 01/02/2006 What I want to be able to do is in a seperate cell, add up the value of ££££'s for a given date that have been NOT COLLECTED PLEASE HELP!!!!!!!!!!!!!!!!!! -- stapleton2308 ------------------------------------------------------------------------ stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878 View this thread: http://www.excelforum.com/showthread...hreadid=538125 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please Help!!!!!!!!
=SUMPRODUCT(--(C1:C5=--"2006-02-01"),--(B1:B5="NOT COLLECTED"),--(A1:A5)) HTH "stapleton2308" wrote: Basically I have the following data: £2500 COLLECTED 01/03/2006 £3500 NOT COLLECTED 01/02/2006 £4500 COLLECTED 01/03/2006 £3000 COLLECTED 01/03/2006 £3500 NOT COLLECTED 01/02/2006 What I want to be able to do is in a seperate cell, add up the value of ££££'s for a given date that have been NOT COLLECTED PLEASE HELP!!!!!!!!!!!!!!!!!! -- stapleton2308 ------------------------------------------------------------------------ stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878 View this thread: http://www.excelforum.com/showthread...hreadid=538125 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
