在EXCEL里怎么样作简单地作这个公式？

来源：百度知道 编辑：UC知道 时间：2024/06/10 10:38:03
=C4-H5-H6-H7-H8-H9-H10-H11-H12-H13-H14-H15-H16-H17-H18-H19-H20-H21-H22-H23-H24-H25-H26-H27-H28-H29-H30-H31-H32-H33-H34-H37-H38-H39-H40-H41-H42-H43-H44-H45-H46-H47-H48-H49-H50-H51-H52-H53-H54-H55-H56-H57-H58-H59-H60-H61-H62-H63-H64-H65-H66-H67-H68-H69-H70-H71-H72-H73-H74-H75-H76-H77-H78-H79-H80-H81-H82-H83-H84-H85-H86-H87-H88-H89-H90-H91-H92-H93-H94-H95-H96-H97-H98-H99-H100-H101-H102-H103-H104-H105-H106-H107-H108-H109-H110-H111-H112-H113-H114-H115-H116-H117-H118-H119-H120-H121-H122-H123-H124-H125-H126-H127-H128-H129-H130-H131-H132-H133-H134-H135-H136-H137-H138-H139-H140-H141-H142-H143-H144-H145-H146-H147-H148-H149-H150-H151-H152-H153-H154-H155-H156-H157-H158-H159-H160-H161-H162-H163-H164-H165-H166-H167-H168-H169-H170-H171-H172-H173-H174-H175-H176-H177-H178-H179-H180-H181-H182-H183-H184-H185-H186-H187-H188-H189-H190-H191-H192-H193-H194-H195-H196-H197-H198-H199-H200-H201-H202.........
我是问有没有简单的方法可以这样作？

这个公式是有些复杂，但还是有很简单的实现方法。
C4-(sum(H5:Hxxx))其中xxx就是要结束的那个数字。
sum是把这些数字求和。

=C4-SUM(H5:H34,H37:H202)

在单元格中输入“=C4-SUM( 用鼠标选中你要减的单元格)”回车就可以了。

这样也叫简单？汗~~~~~~~~~~~~~~~~~~~~~~~~~