sumif function

[bknight]

I have a spreadsheet that I would like to sum if a criteria is met.
Column R contains the number. Column O contains alpha characters that are the criteria
=SUMIF(R2:R88,"Account_display_name"="APEX-127186-07!Apex!Apex")
=SUMIF(R2:R88,O1="APEX-127186-07!Apex!Apex")
I'm doing something wrong as the result is zero, not possible.

[HansV]

The syntax of SUMIF is

=SUMIF(criteria_range, criteria, sum_range)

So you probably want

=SUMIF(O2:O88, "APEX-127186-07!Apex!Apex", R2:R88)

[SpeakEasy]

I think you may be looking for something more like:

=SUMIF(O2:O88,"=APEX-127186-07!Apex!Apex",R2:R88)

[SpeakEasy]

Aha! Too slow again!

[bknight]

Aha! Too slow again!

But still worked.