The formula is summing all of
3001 3000D 3000K 3000X 3002 3002D 3002K 3002X 3003 3003D 3003K 3003X 3004 3004D 3004K 3004X 3005 3005D 3005K 3005X 3006 3006D 3006K 3006X 3007 3007D 3007K 3007X 3008 3008D 3008K 3008X 3009 3009D 3009K 3009X 3015 3015D 3015K 3015X
And the value should be (2,175,478)
To get the value you are looking for, you could use
=SUM(IFERROR((--Sheet1!F1:F4310)>=3000,0)*IFERROR((--Sheet1!F1:F4310)<=3015,0)*(Sheet1!H1:H4310)) as array formula
Last edited by Excel Fox; 04-06-2013 at 05:19 PM. Reason: Additional Info
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Hi Admin
My Apologies. I rechecking the attached file, I found that a number of values had blanks. Your formula works perfectly.
Regards
Howard
Hi Admin
I would be appreciated if you could amend the formula in cell C6 on sheet "account classification" -see attached workbook. I have set up your formula which gives me an incorrect result. I have also set a a Vlookup to give me the values per account number on sheet "account classification" pertaining to the values on sheet1 for the range 3000 to 3015 (four digit account numbers only)
1) Adding Range of account numbers 3000 to 3015 -where the account numbers are in Col C and values Col E i.e four digit account numbers only
2) Range of account numbers 3000D to 3015D -where the account numbers are in Col C and values Col E i.e five digit account numbers ending in D eg 3001D
Your assistance in resolving this is most appreciated
Last edited by Howardc; 04-07-2013 at 01:33 PM.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks