Help with Countifs in multiple ranges & multiple criteria

Hi all,

I'm having a sample of problem with my excel regarding with countifs function.

for now im using this formula :

=COUNTIFS(Table1[[J41]:[J41ii]],[@INT],Table1[ON/OFF],"ON",Table1[COST],"<2,000,000")+(COUNTIFS(Table1[[J41]:[J41ii]],[@INT],Table1[ON/OFF],"ON",Table1[COST],">=2,000,000",Table1[COST],"<4,000,000")*2)

and the result is #value! , anyone can help me with this problem?



im sorry if
1. my english bit bad
2. i dont know how to use VBA

thank you. its really help alot.