Formula Error

[O_Junior]

I'm trying to do this formula: =IF(A7:A1000="RL1";IF(G7:G1000=TODAY();SUM(I7:I1000);"");"") but i keep getting an error. My guess is that =TODAY() is wrong, but i'm not sure. Could someone help me?

 

[Brian from Maui]

I'm trying to do this formula: =IF(A7:A1000="RL1";IF(G7:G1000=TODAY();SUM(I7:I1000);"");"") but i keep getting an error. My guess is that =TODAY() is wrong, but i'm not sure. Could someone help me?

Try using SUMIFS.

 

[Aladin Akyurek]

I'm trying to do this formula: =IF(A7:A1000="RL1";IF(G7:G1000=TODAY();SUM(I7:I1000);"");"") but i keep getting an error. My guess is that =TODAY() is wrong, but i'm not sure. Could someone help me?

Control+shift+enter, not just enter:

=SUM(IF(A7:A1000="RL1";IF(G7:G1000=TODAY();I7:I1000)))

Or just enter:

=SUMIFS(I7:I1000;A7:A1000;"RL1";IG7:G1000;TODAY())

 

[Andrew Poulsom]

Does this work for you?

=SUMIFS(I7:I1000;A7:A1000;"RL1";G7:G1000;TODAY())

 

[O_Junior]

Does this work for you?

=SUMIFS(I7:I1000;A7:A1000;"RL1";G7:G1000;TODAY())

Nope!

 

[Aladin Akyurek]

Nope!

See post #3 for the array formula...

 

[O_Junior]

Does the VBA influence in something? Cause i got some VBA going on on this sheet.

 

[Aladin Akyurek]

Does the VBA influence in something? Cause i got some VBA going on on this sheet.

What are you taking about? Does this...

=SUM(IF(A7:A1000="RL1";IF(G7:G1000=TODAY();I7:I1000)))

not work, which you need to confirm with control+shift+enter, not just enter?

 

[O_Junior]

What are you taking about? Does this...

=SUM(IF(A7:A1000="RL1";IF(G7:G1000=TODAY();I7:I1000)))

not work, which you need to confirm with control+shift+enter, not just enter?

I did press control+shift+enter, but the value is always 0.

 

[Aladin Akyurek]

I did press control+shift+enter, but the value is always 0.

1) Do you see { and } around the formula on the formula bar?

2) Since the formula was crafted after your own effort, can you perhaps describe in words what you intended to calculate with that?