Help with Excel complex formulas

Closed
stressed123 - Jul 8, 2010 at 12:53 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 9, 2010 at 05:01 PM
Hello,

Currently using MS excel 2003. I have the following formula thats generating a value of 0.
If I do individual filters it will provide me with the value that I need.

=SUMPRODUCT((C2:C20>200)*(E2:E20="*home*")*(L2:L20="No Date"))

If I filter on col C then column E then column L....I get the desired result.

I am fairly new at writing formulas, so I may not be using this correctly.

Hope you can help.

Diana


Related:

2 responses

Stroller Posts 3 Registration date Thursday July 8, 2010 Status Member Last seen July 8, 2010
Jul 8, 2010 at 02:24 PM
Is the a school assignment?
Can you please add what type of calculation you are trying to make excell perform?

Excell is a very strong program and from what I have found not even the program designers are completely positive of what all it can do. There is a completely seperate tutorial for math in excell and it shows all kinds of tricks.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 9, 2010 at 05:01 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too