I am using the following formula (as an example):
=SUMIFS(G$2:G$2000,$A$2:$A$2000,"6*",$B$2:$B$2000,"3*")
To find the sum of the numbers in column G where column A starts with a 6 and column B starts with a 3.
It works for values like the following:
6.093, 6.095 | 3.113, 3.115
But not for single values like this:
3.105 | 6.021
However, if I put a comma after the singular values it then can identify it:
3.105, | 6.021,
See the attached example for reference where it only sums rows 2 and 4 but I want it to sum the values in 3 as well. I have tried changing the "non-comma" example to text but this did not work. Why doesn't it identify the numbers without commas and how can I get it to do that?
Thanks!
Bookmarks