SUMIF only works for 1 column and not the other?

[SensingFailure]

Good morning all!

So I have a spreadsheet where I have to compare monthly hour and cycle updates to aircraft. I need to show how much of an increase occurs each month and to catch any decreases. I have had success using SUMIF for the hours updates, but not the cycles. It only displays the formula text rather than a value. I thought that it may have been related to the specified cells being 1 more column to the right from the range criteria.

The formula that is not working is:
=SUMIF(D3:$D$616,AM3,$F$3:$F$616)-SUMIF($A$3:$A$579,AM3,$C$3:$C$579)
yet it works for the hours with this formula:
=SUMIF($D$3:$D$616,AM3,$E$3:$E$616)-SUMIF($A$3:$A$579,AM3,$B$3:$B$579)

Any help on this is greatly appreciated!

[TABLE="width: 448"]
<tbody>[TR]
[TD="class: xl67, width: 64"]January[/TD]
[TD="class: xl67, width: 64"][/TD]
[TD="class: xl67, width: 64"][/TD]
[TD="class: xl67, width: 64"]February[/TD]
[TD="class: xl67, width: 64"][/TD]
[TD="class: xl67, width: 64"][/TD]
[TD="class: xl67, width: 64"]March[/TD]
[/TR]
[TR]
[TD="class: xl66"]Tail[/TD]
[TD="class: xl66"]A/C TSN[/TD]
[TD="class: xl66"]A/C CSN[/TD]
[TD="class: xl66"]Tail[/TD]
[TD="class: xl66"]A/C TSN[/TD]
[TD="class: xl66"]A/C CSN[/TD]
[TD="class: xl66"]Tail[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]N200WN[/TD]
[TD="class: xl70, width: 64"]32347[/TD]
[TD="class: xl68, width: 64"]18921[/TD]
[TD="class: xl65"]N200WN[/TD]
[TD="class: xl71, width: 64"]32635[/TD]
[TD="class: xl69, width: 64"]19090[/TD]
[TD="class: xl65"]N200WN[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]N201LV[/TD]
[TD="class: xl70, width: 64"]32254[/TD]
[TD="class: xl69, width: 64"]18687[/TD]
[TD="class: xl65"]N201LV[/TD]
[TD="class: xl70, width: 64"]32517[/TD]
[TD="class: xl69, width: 64"]18839[/TD]
[TD="class: xl65"]N201LV[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]N202WN[/TD]
[TD="class: xl70, width: 64"]32324[/TD]
[TD="class: xl69, width: 64"]18847[/TD]
[TD="class: xl65"]N202WN[/TD]
[TD="class: xl70, width: 64"]32589[/TD]
[TD="class: xl69, width: 64"]19007[/TD]
[TD="class: xl65"]N202WN[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]N203WN[/TD]
[TD="class: xl70, width: 64"]32146[/TD]
[TD="class: xl69, width: 64"]18749[/TD]
[TD="class: xl65"]N203WN[/TD]
[TD="class: xl70, width: 64"]32410[/TD]
[TD="class: xl69, width: 64"]18911[/TD]
[TD="class: xl65"]N203WN[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]N204WN[/TD]
[TD="class: xl70, width: 64"]32279[/TD]
[TD="class: xl69, width: 64"]18645[/TD]
[TD="class: xl65"]N204WN[/TD]
[TD="class: xl70, width: 64"]32544[/TD]
[TD="class: xl69, width: 64"]18809[/TD]
[TD="class: xl65"]N204WN[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]N205WN[/TD]
[TD="class: xl70, width: 64"]31987[/TD]
[TD="class: xl69, width: 64"]18686[/TD]
[TD="class: xl65"]N205WN[/TD]
[TD="class: xl70, width: 64"]32251[/TD]
[TD="class: xl69, width: 64"]18845[/TD]
[TD="class: xl65"]N205WN[/TD]
[/TR]
</tbody>[/TABLE]

Note: This is just a small example, most tail numbers do not remain in the same rows such as this.

 

[Jonmo1]

Welcome to the board.

It only displays the formula text rather than a value..

Format the cells as General (anything other than Text really) then RE-Enter the formula.

 

[par60056]

Welcome to the forum.

Are you copying the formula? Can it be the $ missing on the D3?

 

[SensingFailure]

Hello, and thanks for the welcome!

I have already formatted everything as general and no I am not copying the formula at this time. I plan to, but I am getting this error after writing the first entry.

 

[DKaur]

I don't see anything wrong with your formula. I tested it in a seperate spreadsheet and it was fine. The only reason it would show the formula text is if you have forgotten to put an equals sign in or the formula was in quotation marks. It works even when columns F and C are text types. What is in AM3?

 

[SensingFailure]

AM3 is the criteria/value of the cell I want to have searched for in my range, which subsequently is "N500WR".

 

[Jonmo1]

I have already formatted everything as general

The key step in my suggestion was to RE-Enter the formula.
I should have specified to do that AFTER formatting as General.

Format the cells as General (anything other than Text really) then RE-Enter the formula.

 

[SensingFailure]

So I found my problem... The value I was using as my criteria had not yet appeared in my range. Once I moved the formula to a month that it had appeared it worked perfectly. Dangit! Sorry for not realizing sooner. Thanks for the help though!