Hi,
i think there is a problem with the formula, it is working but not picking
up the correct value.
i have emailed you on your yahoo address to ask if its ok that i email you
the sample spreadsheet so you can see the problem.
thanks alot.
"Max" wrote:
One way:
=SUMPRODUCT((B2:B122=C123)*(D2:D1220)*D2:D122)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Zak" wrote:
I have the following SUMIF statement but i would like to modify the formula
so it only counts the the negative numbers, i tried if<0 but no luck.
=SUMIF(B2:B122,C123,D2:D122)
the D reference should say somewhere 'if less than 0' - so it only counts
negative numbers.
thanks for your help.