Sumif Problem

**AmsterDan** · 10-17-2011, 02:22 PM

Hi there,

I came here a while back with the same sheet, except that I have a problem which I believe is easily solved through a SUMIF statement.

Basically what I'd like to do, see attached file as example, is to have the cell 'Other' in the table named 'Fuel Breakdown' to add all other fuel numbers other than the already existing call signs.

So, HJL, HJG, HJT etc have their own sumif statement in the fuel breakdown window, but let's say an aircraft with callsign BBB comes in and then an aircraft CCC comes in and they take fuel, how can I make the 'Other' sumif statement add their fuel number?

The help is much appreciated, as always!

Daniel

**NBVC** · 10-17-2011, 02:28 PM

Couldn't you use?

=SUM($G$6:$G$34)-SUM($H$38:$H$43)-SUM($J$38:$J$42)

so basically sum of all the entries minus the sumifs for each of the "desired" categories.

**arlu1201** · 10-17-2011, 02:30 PM

One way that i can think of is do a sum of the entire column and minus the sumifs already calculated for the other call signs. For e.g. =sum(column) -sum(cells where sumif is calculated for HJL, HJG,etc)