format - Excel SUM\SUMIF based on cell percentage formatting -
i copy old post because solution worked inverse of need. have same type of list of data, cells formatted number, , percentage respectively.
i have row containing cells different formatting
they following
85 32% 45 23% 11 5% result need achieve sum number formatted cells (not percentage ones) without additional rows. no clue how it.
so need inverse if possible can add %. thanks. mack
lets values in a1:a4, copy formula b1:b4
=cell("format";a1) & t(now())
then write formula sum values %
=sumif(b1:b4;"p*";a1:a4)
the formula in b1:b4 volatile still need press f9, recalculate sumif, if change format in a1:a4 without changing value
Comments
Post a Comment