runningonempty
New Member
- Joined
- Aug 7, 2007
- Messages
- 35
account code £££s
911112 aab 1000
912222 aaa 1500
911112 aab 2000
911112 aaa 2500
924664 acc 3000
955232 aca 3500
911112 acb 4000
formula =SUMPRODUCT(--(E4:E10=E18),--(F4:F10=F18),(G4:G10))
result 3500
criteria 955232 aca
Dilemma? How do I sumproduct using left function 2 place on code column?
I only want for eg account codes 911112 with codes starting with ac??
Criteria ??? 911112 ac
Please help, thanks, also how do I copy spreadsheet into message board so it looks just like i am seeing it on excel with rows and columns etc?
911112 aab 1000
912222 aaa 1500
911112 aab 2000
911112 aaa 2500
924664 acc 3000
955232 aca 3500
911112 acb 4000
formula =SUMPRODUCT(--(E4:E10=E18),--(F4:F10=F18),(G4:G10))
result 3500
criteria 955232 aca
Dilemma? How do I sumproduct using left function 2 place on code column?
I only want for eg account codes 911112 with codes starting with ac??
Criteria ??? 911112 ac
Please help, thanks, also how do I copy spreadsheet into message board so it looks just like i am seeing it on excel with rows and columns etc?