I'm not really sure what you are attempting to accomplish here, but wouldn't it be easier to simply drop all of the chained IF clauses inside of your SUM function and simply use the SUMIF function instead?

Oron Joffe

August 15, 2013 at 12:57 pm

A difficult question! The way I would deal with this situation (and I think this is standard practice) is as follows:
1. Create an intermediate value in another column (let's say, column Z), and in Z58 type =IF(G58&I58="fare querykul") .
2. Copy that down the column to fill Z58:Z90
3. Now revise your formula to read =SUM(Z58-90).
fdsf
This is not really shorter (in fact, it's probably both takes up more screeen space & RAM, and is a little slower to compute). However, it's much easier to read/understand and more flexible. Need to add a few rows? No problem, add them, and fill the Z column acordingly. Remove a few lines? Likewise.

The reason it's so difficult to do in Excel is that, although there are various tools built into Excel to deal with things like this (array functions, SUMIF etc), they all deal with ONE value at a time (e.g. column G="fare query"), not the logical combination two values, as you have here. In the future, consider modifying the design of the spreadsheet accordingly.