| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Sumif = and between
Hi all I am having trouble summing the following data A B C D E 1 1/2/05 2/5/05 10 Big 1/2/05 856 11 Small 2/5/05 1050 12 Big 2/5/05 769 Sum If A:A=Big and Between D1 and E1 should = 1625 -- mathewheys ------------------------------------------------------------------------ mathewheys's Profile: http://www.msusenet.com/member.php?userid=905 View this thread: http://www.msusenet.com/t-1870400614 |
|
#2
|
|||
|
|||
|
Hi all I am having trouble summing the following data A B C D E 1 1/2/05 2/5/05 10 Big 1/2/05 856 11 Small 2/5/05 1050 12 Big 2/5/05 769 Sum If A:A=Big and Between D1 and E1 should = 1625 -- mathewheys ------------------------------------------------------------------------ mathewheys's Profile: http://www.msusenet.com/member.php?userid=905 View this thread: http://www.msusenet.com/t-1870400614 |
|
#3
|
|||
|
|||
|
=SUMPRODUCT(--(A2:A10="Big"),--(B2:B10=D1),--(B2:B10<=E1),C2:C10)
you can't use the whole range (A:A) so you need to specify the ranges -- Regards, Peo Sjoblom "mathewheys" wrote in message ... Hi all I am having trouble summing the following data A B C D E 1 1/2/05 2/5/05 10 Big 1/2/05 856 11 Small 2/5/05 1050 12 Big 2/5/05 769 Sum If A:A=Big and Between D1 and E1 should = 1625 -- mathewheys ------------------------------------------------------------------------ mathewheys's Profile: http://www.msusenet.com/member.php?userid=905 View this thread: http://www.msusenet.com/t-1870400614 |
|
#4
|
|||
|
|||
|
This only works for the first 10 cells -- mathewheys ------------------------------------------------------------------------ mathewheys's Profile: http://www.msusenet.com/member.php?userid=905 View this thread: http://www.msusenet.com/t-1870400614 |
|
#5
|
|||
|
|||
|
Well change it then?
-- Regards, Peo Sjoblom "mathewheys" wrote in message ... This only works for the first 10 cells -- mathewheys ------------------------------------------------------------------------ mathewheys's Profile: http://www.msusenet.com/member.php?userid=905 View this thread: http://www.msusenet.com/t-1870400614 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
