Mirandaleecon
New Member
- Joined
- Mar 3, 2016
- Messages
- 4
Hello!
How can I sum only positive numbers that are not in a range. I have tried sumif several different ways and I cannot get it to work without a range.
A B C D E F
-5 -4 -2 3 1 -8
Take the above example. I would only like to sum A, C, and E. What formula would I need to put in to get the answer '1'??
The spreadsheet I'm working needs to sum about 100 alternating cells like this so it needs to be relatively simple.
Thank you!
How can I sum only positive numbers that are not in a range. I have tried sumif several different ways and I cannot get it to work without a range.
A B C D E F
-5 -4 -2 3 1 -8
Take the above example. I would only like to sum A, C, and E. What formula would I need to put in to get the answer '1'??
The spreadsheet I'm working needs to sum about 100 alternating cells like this so it needs to be relatively simple.
Thank you!