❓ Help About excel

[usersusername]

gusto ko isum lahat kaso everytime na lilitaw ang name ni "product1" gusto wag sya maisama sa total.

 

[Scavenger]

sum sa whole column range minus sum if (condition = product 1)
sa example mo:
=sum(C6:C9) - sumif(A6:A9, "product1", C6:C9)

better formula:
=sumif(A6:A9, "<>product1", C6:C9)
meaning, summing C6 to C9 excluding product1 in column A6 to A9

 

[usersusername]

sum sa whole column range minus sum if (condition = product 1)
sa example mo:
=sum(C6:C9) - sumif(A6:A9, "product1", C6:C9)

better formula:
=sumif(A6:A9, "<>product1", C6:C9)
meaning, summing C6 to C9 excluding product1 in column A6 to A9

salamat laking tulong nito
galing, works like magic

 

[usersusername]

Scavenger patulong ulit.

pag input ko ng 29.3 palilitawin agad ung VALUE. pagka whole number walang gagawain.

 

[Scavenger]

Scavenger patulong ulit.

pag input ko ng 29.3 palilitawin agad ung VALUE. pagka whole number walang gagawain.

ganito ba lods??

pwede din filter gagamitin mo instead na formula. Here's a comprehensive guide for filtering whole numbers and decimals: You do not have permission to view the full content of this post. Log in or register now.

 

[usersusername]

ganito ba lods??
View attachment 1787840
pwede din filter gagamitin mo instead na formula. Here's a comprehensive guide for filtering whole numbers and decimals: You do not have permission to view the full content of this post. Log in or register now.

ganito sana. kapag ung 29 dinagdagan ko ng .1 palitawin sana ung value na 33.8

 

[Scavenger]

ganito sana. kapag ung 29 dinagdagan ko ng .1 palitawin sa ung value na 33.8

ahh.. need mo mag set ng range of values nyan tapos vlookup..
kasi parang specific value yata gusto mo hindi logical based sa example mo.

hindi ko kasi masyadong ma gets yung equivalent value ng CM.. san mo ba na derived yun??
kasi you could use the derivation as formula para maging automatic..yun sana sagot sa gusto mong mangyari

 

[usersusername]

ahh.. need mo mag set ng range of values nyan tapos vlookup..
kasi parang specific value yata gusto mo hindi logical based sa example mo.

hindi ko kasi masyadong ma gets yung equivalent value ng CM.. san mo ba na derived yun??
kasi you could use the derivation as formula para maging automatic..yun sana sagot sa gusto mong mangyari

salamat ok na sya.