*From:* Mark Kerin
> *Sent:* Friday, June 01, 2012 1:43 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ vba formula vs calculation - problem with
> "<=" or dates
>
>
> This formula works in a cell:
> =SUMIFS(O$2:O$26196,A$2:A$26196,A2,N$2:
There may? be a better way to do this. Reply to ME at the address below with
your file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Mark Kerin
Sent: Friday, June 01, 2012 1:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ vba formula vs
Thank you Noorain.
Yes, Evaluate() does put a value in the cell instead of a formuala. That is
great.
Do you have any idea how to make the equation include "<=" in the last
clause?
On Friday, June 1, 2012 8:58:42 PM UTC-4, NOORAIN ANSARI wrote:
> Dear Mark,
>
> You can try..
> .
> .Range("q"
Dear Mark,
You can try..
.
.Range("q" & i).Formula = *Evaluate(*"=SUMIFS(O$2:O$26196,A$2:A$26196," &
"a" & i & ",N$2:N$26196," & "n" & i & ")"*)*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Sat, Jun 2, 2012 at 12:13 AM, Mark Kerin wrote:
>
> T
This formula works in a cell:
=SUMIFS(O$2:O$26196,A$2:A$26196,A2,N$2:N$26196,"<="&N2)
1) I want to have vba make this calculation - because calculating it in
each cell bogs down the xls.
I got the following vba to work but I cant figure out how to add "<=" to
the last clause (col N has dates):
.R
