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.
sumif function
-
- Administrator
- Posts: 79695
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: sumif function
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)
=SUMIF(criteria_range, criteria, sum_range)
So you probably want
=SUMIF(O2:O88, "APEX-127186-07!Apex!Apex", R2:R88)
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 667
- Joined: 27 Jun 2021, 10:46
Re: sumif function
I think you may be looking for something more like:
=SUMIF(O2:O88,"=APEX-127186-07!Apex!Apex",R2:R88)
=SUMIF(O2:O88,"=APEX-127186-07!Apex!Apex",R2:R88)
-
- 5StarLounger
- Posts: 667
- Joined: 27 Jun 2021, 10:46
Re: sumif function
Aha! Too slow again!
-
- BronzeLounger
- Posts: 1589
- Joined: 08 Jul 2016, 18:53