About SUMIF & SUM+IF

[MBS]

Dear All,
I wander why array created is not recognized by COUNTIF or SUMIF as "RANGE".
What is technical difference between =SUMIF() and =SUM(IF())

Thanks.

Start Date	End Date	Number Of Days Except Sunday
02-07-2022​	23-07-2022​	19​	=SUM(IF(WEEKDAY(ROW(INDIRECT(A5&":"&B5)),2)<>7,1))
		=COUNTIF((WEEKDAY(ROW(INDIRECT(B5&":"&C5)),2)<>7)*1,1)
		=COUNTIF({1;0;1;1;1;1;1;1;0;1;1;1;1;1;1;0;1;1;1;1;1;1},1)
		Why COUNTIF (& SUMIF) recognize the range to COUNTIF or SUM

 

[GraH - Guido]

Because a range <> array. A range is a collection of cells, whereas an array is a collection of values.
Not all function can handle array as inputs or outputs.

But you can use

=NETWORKDAYS.INTL(A3,B3,11)