ExcelBanter - Sumif = and between

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sumif = and between (https://www.excelbanter.com/excel-worksheet-functions/24563-sumif-%3D-between.html)

mathewheys

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

mathewheys

Peo Sjoblom

=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

mathewheys

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

Peo Sjoblom

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

All times are GMT +1. The time now is 09:48 AM.