Thread
:
Use different formula to calculation based on conditions
View Single Post
#
3
Posted to microsoft.public.excel.misc
[email protected]
Posts: n/a
Use different formula to calculation based on conditions
Errata ....
I wrote:
=(SUMIF(C1:C10,"Asset A",B1:B10)
-1000*COUNTIF(C1:C10,"Asset A",B1:B10))*3/5
Of course, that should be COUNTIF(C1:C10,"Asset A").
Reply With Quote
Use different formula to calculation based on conditions