F
faureman via OfficeKB.com
In a tracking sheet, I differentiate between uninstalled equipment (in bold)
and installed equipment (non-bold). Many cells in the same range are
unassigned and thus left blank.
The formula that I'm using is: =countBold(T11:T98). This formula is working
perfectly for identifying that a particular contains bold formatting. The
problem is that the quantity entered in that cell is not allowing a proper
sum total - obviously because I'm using a count formula instead of sum
formula. In other words, I'm trying to find a way to only sum the bold cell
quantities.
Example... cell T30 has a quantity of '3'. Cell T50 has a quantity of '2'.
Both cells are formatted bold. Some cells have quantities that are non-bold
and summed separately. The countBold formula is only returning a value of '2'
as it is only counting two cells as being formatted in bold throughout the
given range.
Ideally, I want to use bold for new equipment - then sum the quantities in
bold through the entire range. In the simplified example above, the desired
return sum should equal '5' rather than the countBold value of '2'. I think I
require some sort of conditional 'sumif' or compound formula to find a
solution.
I know I could easily break this into two columns - but this is exactly what
I'm trying to avoid as I have multiple columns tracking hardware similarly.
The benefit is that I can quickly unbold the new equipment as it is unstalled
to track progress as well as maintaining tallies.
If an alternative can be presented that will accomplish the same thing but
still adhering to using only 1 column... please feel free to submit it
instead.
Thanks.
and installed equipment (non-bold). Many cells in the same range are
unassigned and thus left blank.
The formula that I'm using is: =countBold(T11:T98). This formula is working
perfectly for identifying that a particular contains bold formatting. The
problem is that the quantity entered in that cell is not allowing a proper
sum total - obviously because I'm using a count formula instead of sum
formula. In other words, I'm trying to find a way to only sum the bold cell
quantities.
Example... cell T30 has a quantity of '3'. Cell T50 has a quantity of '2'.
Both cells are formatted bold. Some cells have quantities that are non-bold
and summed separately. The countBold formula is only returning a value of '2'
as it is only counting two cells as being formatted in bold throughout the
given range.
Ideally, I want to use bold for new equipment - then sum the quantities in
bold through the entire range. In the simplified example above, the desired
return sum should equal '5' rather than the countBold value of '2'. I think I
require some sort of conditional 'sumif' or compound formula to find a
solution.
I know I could easily break this into two columns - but this is exactly what
I'm trying to avoid as I have multiple columns tracking hardware similarly.
The benefit is that I can quickly unbold the new equipment as it is unstalled
to track progress as well as maintaining tallies.
If an alternative can be presented that will accomplish the same thing but
still adhering to using only 1 column... please feel free to submit it
instead.
Thanks.