You probably have values in B1 to B425 that are *not* true XL recognized
numbers!
Could B1 be a text header?
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
"Minx" wrote in message
...
=SUMPRODUCT((Xewks!A1:A425=A10)*(Xewks!E1:E425=5)* (Xewks!D1
425="B
Borrow")*Xewks!B1:B425)
Here is what I put in for my SUMPRODUCT formula, but it just gives me a
#VALUE error. Closer than what I was doing before, but still not working -
so
I must be misunderstanding something.
Thank you for your help!
"RagDyeR" wrote:
Assign your "given values" to particular cells, so they can easily be
changed, without having to revise the formula itself (E1, E2).
=Sumproduct((A1:A100=E1)*(D1100=E2)*C1:C100)
To add other criteria, simply add another argument:
=Sumproduct((A1:A100=E1)*(D1100=E2)*(B1:B100=E3) *C1:C100)
All ranges should be the same size, and you *cannot* use entire columns
(A:A - B:B)