sumif function

bknight
BronzeLounger
Posts: 1589
Joined: 08 Jul 2016, 18:53

sumif function

Post by 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.

User avatar
HansV
Administrator
Posts: 79699
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: sumif function

Post by 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)
Best wishes,
Hans

User avatar
SpeakEasy
5StarLounger
Posts: 667
Joined: 27 Jun 2021, 10:46

Re: sumif function

Post by SpeakEasy »

I think you may be looking for something more like:

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

User avatar
SpeakEasy
5StarLounger
Posts: 667
Joined: 27 Jun 2021, 10:46

Re: sumif function

Post by SpeakEasy »

Aha! Too slow again! :smile:

bknight
BronzeLounger
Posts: 1589
Joined: 08 Jul 2016, 18:53

Re: sumif function

Post by bknight »

SpeakEasy wrote:
04 Jun 2024, 18:28
Aha! Too slow again! :smile:
But still worked.