Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hey All-
I was wondering if anyone could help me with this formula. The syntax is incorrect, however, this is what I would like the calculations to accomplish. I'm aware SUM means SUM, however, I need a way to subtract those cells that are listed. Maybe I've been looking at this formula too long since I'm stumped. Thanks in advance for any help you can offer! Chris Formula =IF(SUM(G24:G91-G87:G90)/SUM(F24:F91-G87:G90),SUM(G24:G91-G87:G90)/SUM(F24: F91-G87:G90),"") -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
I need assistance with wrting an Excel formula | Excel Worksheet Functions |