Sumproduct is not written in this way to use the operator as string, i
did'nt saw any example like this in last 4-5 years
Rajan
On Wednesday, 9 January 2013 01:06:35 UTC-7, Aashish Watve wrote:
>
> Hi All,
>
> I am seeing many examples of SUMPRODUCT formula on this forum and very
> interested in using this in my assignment. I see that this formula is very
> short and fast.
>
> I am presently using SUMIFS for most of my calculations, where I am
> creating the SUMIF formula in a cell by concatenating entries from the
> cells. Please find attached a sample excel file that shows what I am doing.
> I am doing this because I am working with more than 50000 rows and by
> changing entries in one of the columns I can easily change the formula.
> This is very powerful when I have such a huge data.
>
> One problem, which I am finding with SUMPRODUCT formula is that, I am able
> to replace the values with the cell entries, but not able to replace the
> mathematical symbols ("<", ">", "<=" or "<>"). Has anyone tried this with
> SUMPRODUCT?
>
> Any Help on this would be appreciated.
>
> Regards,
> Aashish
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
