G
Guest
I have 3 col of information:
Col A=dates
Col B=acct numbers
Col 3=currency
I'm trying to find the sum of Col 3 based on a date range in Col A and
certain numbers in Col B
Col A Col B Col C
12/19/06 42016 500
01/03/07 42011 200
03/15/07 42011 150
03/31/07 42011 10
If the question was: Total of Col C during Jan-Mar 2007 in acct 42011 or
42012
Answer: 160
Here is what I was trying to use and am getting #VALUE! error:
=SUMPRODUCT((A1:A4=< 39172)*((F1:F4={42011,42012})*(C2:C500)))
Col A=dates
Col B=acct numbers
Col 3=currency
I'm trying to find the sum of Col 3 based on a date range in Col A and
certain numbers in Col B
Col A Col B Col C
12/19/06 42016 500
01/03/07 42011 200
03/15/07 42011 150
03/31/07 42011 10
If the question was: Total of Col C during Jan-Mar 2007 in acct 42011 or
42012
Answer: 160
Here is what I was trying to use and am getting #VALUE! error:
=SUMPRODUCT((A1:A4=< 39172)*((F1:F4={42011,42012})*(C2:C500)))