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 [email protected].
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
sample-example.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
