Here is my formula:
=SUMPRODUCT((Testing!$C$2:$C$1000="*OFM*")*(Testing!$E$2:$E$1000="*Issue*"))
I returns a result of zero. I have uploaded a sample workbook below.
The formula in question is on sheet2 cell A1
Here is my formula:
=SUMPRODUCT((Testing!$C$2:$C$1000="*OFM*")*(Testing!$E$2:$E$1000="*Issue*"))
I returns a result of zero. I have uploaded a sample workbook below.
The formula in question is on sheet2 cell A1
Last edited by CityInspector; 11-06-2012 at 09:35 AM.
Could you post an example of the result you are wanting?
Click on the * icon if this post has been helpful.
With the sample set provided, I am not sure you need to use wildcards....
=SUMPRODUCT((Testing!$C$2:$C$1000="OFM")*(Testing!$E$2:$E$1000="Issue"))
btw, wildcards don't work with Sumproduct.
you could use COUNTIFS too.
=COUNTIFS(Testing!$C$2:$C$1000,"OFM",Testing!$E$2:$E$1000,"Issue")
and with this function you can use wildcards...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
NBVC- i didnt realize that about sumproduct. thanks for the info. I tried your countif formula and it worked perfectly, giving me the result of 2. Thanks for the help.
maybe with an pivot table.
see the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks