SUMIF Formula Problem

[gheyman]

I tried to put a SUMIF formula into my spreadsheet only to find it would not function.

=SUMIF((AQ$8,$Z$7:$AN$7,$Z$19:$AN$19)

Everything looked good, no problems with data in cells, the lookup values matched exactly but it did not calculate - no error signs, just a blank result.

So I had a coworker look at it and he gave me a formula he uses when he cant get a basic SumIf formula to work

{=SUM(IF(AQ$8=$Z$7:$AN$7,$Z19:$AN19))}

The strange thing about this formula is, because of the Funky brackets on the end, you can never click in that cell. If you do, the Funky brackets disappear:
=SUM(IF(AQ$8=$Z$7:$AN$7,$Z19:$AN19)) and the formula no longer works. To get it to work again, you need to click in the cell with the formula, go up to the task bar and click in it at the end of the formula and then hit Ctrl+Shift+Enter to get the brackets {} back so the formula calculates again

CRAZY

Is this really what I need to do?? Why doesn’t the basic SUMIF formula work? Does it not like to work horizontally?

 

[NBVC]

The simple SUMIF formula should be:

=SUMIF($Z$7:$AN$7,AQ8,$Z$19:$AN$19)

as for the "funky" version with { } brackets, that is an array formula. Have a read here for more on Array formulas.

 

[gheyman]

Thanks, three people looked at this and no one caught that. You wouldnt think we use SumIf on a regular basis - long day I guess

Thanks