syntax error - formula help!

[bluepenink]

hello

can someone pls tell me what im doing wrong in my formula?..it keeps giving me an error

=SUMIF(left('Count - Invoice'!$F$1:$AW$1,2),'Purge Invoice Summary'!$C$15,INDEX('Count - Invoice'!$F$2:$AW$24,0,MATCH($C17,'Count - Invoice'!$B$2:$B$24,0)))


pls help!!!

 

[T. Valko]

hello

can someone pls tell me what im doing wrong in my formula?..it keeps giving me an error

=SUMIF(left('Count - Invoice'!$F$1:$AW$1,2),'Purge Invoice Summary'!$C$15,INDEX('Count - Invoice'!$F$2:$AW$24,0,MATCH($C17,'Count - Invoice'!$B$2:$B$24,0)))


pls help!!!

You can't use the LEFT function like that.

Maybe this...

=SUMIF('Count - Invoice'!$F$1:$AW$1,'Purge Invoice Summary'!$C$15&"*",INDEX('Count - Invoice'!$F$2:$AW$24,0,MATCH($C17,'Count - Invoice'!$B$2:$B$24,0)))

Assuming the INDEX stuff is correct.