Sumif results of index function

[freshtomm]

Hi,

i need sum values in column F, but only if in column E is date 5.2.2016. The problem is that the values in column E are results of index function. Is it possible?

Thanks.

 

[NARAYANK991]

Hi ,

Does this not work ?

=SUMIF($E$1:$E$17,"05-02-2016",$F$1:$F$17)

Narayan

 

[freshtomm]

No, it isnt.

 

[NARAYANK991]

Hi ,

Can you indicate the answer the formula should return ?

Narayan

 

[freshtomm]

It should be 333.

 

[NARAYANK991]

Hi ,

Why is the 29 in cell F17 not to be included ? That also has the date 05-02-2016 in cell E17.

Narayan

 

[Khalid NGO]

Hi @freshtomm

Adding few things more things, needs to be cleared...

1) Your formula in A1:
=IFERROR(IF((IF(AND(MONTH(A$7)=MONTH($B1),YEAR(A$7)=YEAR($B1)),1,IF(($B1)>(A$7),#REF!+1,"")))>A$8,"",(IF(AND(MONTH(A$7)=MONTH($B1),YEAR(A$7)=YEAR($B1)),1,IF(($B1)>(A$7),#REF!+1,"")))),"")

is copied down till A17, causing circular references in A7 and A8.

2) There are 2 #REF!

3) There is no date in column A, then why you have used MONTH(A7) and YEAR(A7) ?

Regards,

 

[freshtomm]

It is just a part of a bigger piece. We may pretend that in column A are just numbers.

 

[Khalid NGO]

Without having complete information I can only say "Best of Luck"

 

[NARAYANK991]

Hi ,

I have asked a question ; can you answer it ?

Narayan

 

[freshtomm]

There isnt date in E17, because that payment havent been made yet.