Trying to create a sumif formula that will sumif if a range of data contains a real number. So if I have a range of five numbers like this:
10
20
30
10
It should return the sum (70)
It should also return a sum if one of my numbers is zero:
0
0
0
0
Value = 0
If a number is negative, it should also sum, but if no numbers are included in the range of values my answer should be blank.
Thanks for your continued support! I don't know what I'd do without this board!
Brian
10
20
30
10
It should return the sum (70)
It should also return a sum if one of my numbers is zero:
0
0
0
0
Value = 0
If a number is negative, it should also sum, but if no numbers are included in the range of values my answer should be blank.
Thanks for your continued support! I don't know what I'd do without this board!
Brian