View Single Post
  #1   Report Post  
mathewheys
 
Posts: n/a
Default 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