I want to get rid of helper column in SUMIFS formula

[Sean15]

Hello:

I have:

Dates in column F

Negative/positive numbers in column V

Helper column AB is for the month of the date (10/1/17 = 10, 5/31/18 = 5)

The SUMIFS formula below give all the required values:

=SUMIFS($V$2:$V$5000,$V$2:$V$5000,">0",$AB$2:$AB$5000,AD25)

I want to get rid of the helper column. How can I re-work formula to give the required results?


Thanks,

Regards,

Sean

 

[Aladin Akyurek]

Like this...

=SUMIFS($V$2:$V$5000,$V$2:$V$5000,">0",$F$2:$F$5000,">="&AD5,

$F$2:$F$5000,"<="&EOMONTH(AD5,0))

where AD5 houses a first day date of a month/year like 10/1/2017.
​

​

<strike></strike>

 

[Sean15]

Thank you very much Aladin Akyurek

Regards,

Sean

 

[Aladin Akyurek]

You are welcome.