Forum Discussion
Adding up a specific value above a certain value
Hi all, I'm looking for a special formula that so far I've been unable to find. This is a general outline of what I want the formula to do (I hope it's clear enough!): Add up the numbers between...
Oh, and I forgot to add this in my OP. The formula should exclude all letters. So it should only count numbers >0.
Hi Priscilla,
Would you like to say in your cells not only numbers, letters (text) as well? And how it looks like, combined with numbers or one cell number, another text?
If you give typical sample with these 5 cells it'll be bit easier to understand.
- Hi Sergei, thanks for your response.
An example would be something like this:
A1 8
a2 8
A3 6
A4 9
A5 f
It's never a combination of letters and numbers in the same cells. It's always either a number or a letter. I use the spreadsheet to keep track of my working hours, my days off and also the bank holidays (hence the combination of numbers for the hours and the letters to keep track of different days).
I hope this makes it a bit clearer!Yes, thank you.
When simple SUM shall work like
The point is SUM ignores cells with text and logical values. Even better if you put your magic 38 into some cell, let say in A10. Who knows, could be changed on 40 one day...
When the formula could be
=SUM(A1:A5)-$A$10
- Thanks so much! I'm going to give this one a try tomorrow but I think that this is what I'm looking for! I just couldn't figure out the last part of the formula, hahah.