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

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -