how to use curly braces for searching multiple values in an array

[sheelamk]

how to take cell value reference inside curly braces
for eg.,feedersinterruption_dailyentry!$F$3:$F$933,({"ocr","efr"}),This will give correct value
but if i put cell reference it is not taking cell value reference feedersinterruption_dailyentry!$F$3:$F$933,({&B6,&C6})

 

[pecoflyer]

Maybe feedersinterruption_dailyentry!$F$3:$F$933,({INDIRECT(B6),INDIRECT(C6)})
( no file added - untested)

 

[sheelamk]

please check the attached file,i want to calculate total duration of ocr and efr,please suggest formula

 

[Debaser]

Curly brackets are for array constants, which cell references are not. You just need:

=SUM(SUMIFS(D4:D13,C4:C13,G5:G6))

 

[sheelamk]

it is not giving correct answer ,i want to calculate total duration of ocr and efr

 

[p45cal]

it is not giving correct answer ,i want to calculate total duration of ocr and efr

It gives the same answer as cell C15:

 

[Debaser]

If you aren't on a dynamic array version of Excel, you'll need to array enter the formula using Ctrl+Shift+Enter.

 

[Peter Bartholomew]

if the two selected reasons were non-adjacent you could pick the contents up as an array by using
= SUM(SUMIFS(Duration, Reason, CHOOSE({1,2}, selection1, selection2)))
With 365 I would be more inclined to use
= SUM(SUMIFS(Duration, Reason, VSTACK(selection1, selection2)))
(Note: Every formula I write uses defined names and arrays so may not suit your style)