Please can someone advise me where I am going wrong with my SUMIFS formula. Formula worked fine on calculating my outgoing funds however with the incoming it doesn't seem to want to calculate?
Your help will greatly be appreciated.
Asked
Active
Viewed 1,966 times
2
-
1@ScottCraner it is J12 and not J2. Visually data seems to be correct but somewhere user has more space or some other invisible char. – shrivallabha.redij Apr 23 '18 at 13:28
-
Probably Col:B, Col:C values or `J12` have some extra spaces, try select the values of these cells and see which is not correct. – Hakan ERDOGAN Apr 23 '18 at 13:58
-
try replace the semi colons with commas – PeterH Apr 23 '18 at 15:02
-
@PeterH why do you think so? – shrivallabha.redij Apr 23 '18 at 16:14
-
@PeterH Some non-English versions of Excel use semicolons as separators in formulas rather than commas. – ImaginaryHuman072889 Apr 23 '18 at 23:06
-
I agree with @HakanERDOGAN that the problem is likely to be hidden characters such as spaces. Try `=len(b3)`, `=leng(j12)` and other cells to check whether the values are all as you expect. – MattClarke Apr 24 '18 at 00:55
-
1Thank you everyone for your input. There was hidden character/space all sorted now. Have a great day! – Lee-Ann Apr 24 '18 at 09:47
1 Answers
0
In order to avoid having to deal with empty spaces you can use wildcards:
SUMIFS(H3:H200,B3:B200,”*INcoming*”,C3:C200,”*”&J12&”*”)
Kaiser
- 1,957
- 1
- 19
- 28