=SOMPRODUCT(($A$2:$A$132=2)*($C$2:$C$132="j")) doesn't work with pocket excel. Does anyone have an alternative?

I can't seem to find how to do this. Want to add every other row in a worksheet. Any ideas? Thanks!

I have a spreadsheet with numbers from 1-20 in column A and a formula that returns either a yes or 0(blank) in column D. I am trying to set a formula that...

In older versions of Excel the formula bar had a "=" sign. The current versions now have the function sign instead. Is there a way to change it back. The "="...

I have a spreadsheet that I want to autofilter, but the design of the spreadsheet is preventing me from picking up all of the data. I downloaded some data out...

I am wondering if I can enter 8 digits in an Excel Cell and have it display as a date without having to put in a "/" or "-" in between. Thanks! Moira

I would like to know if anyone knows how to calculate what 2 week period you are in for a particular year given a date reference, for example. I have a...

How do I get the PO number to change automatically?

Hi, I have been unsuccessful in trying to figure out a formula that will look at data in one spreadsheet and post all of the items found into...

Hi! I have the following - a large contact database is XLS format with address details. I also have a second XLS of Australian post (zip) codes and...

How can I randomly assign a range of numbers to a range of cells without the numbers repeating?

I am trying to determine if it is possible to write a calculation in Excel that will tell me how many days have elapsed from 5/17/1995 to 3/15/2005.

How would one include the following conditions in a folmula IF Column A= A1 and Column B =B1 then C1=1 IF Column A= A2 and Column B =B1 then C1=2 IF Column...

I was wondering if someone could help me here. Im attempting to create an input box that will ask the user for a number and in turn use this number to identify...

I have a list of e-mail addresses. I want to find all the duplicates. I have sorted the list but the list is extremly long. I have not found an effective...

I would like to have a cell that can be autopopulated based on the content of a different cell but also have a drop down menu that can effect the 2nd...

I currently have a sheet that has values in D1-D10. I would not only like to show the total of those cells, but I would like the amount to appear directly...

First of all, I saw this thread back on 1/9/05 and I am sorry to repeat, but I am puzzled on how to insert a company logo to the Footer of my excel spreadsheet...

Hi, I have having a problem with the formular i type in a cell doesn't respond by giving hte answer, however it just shows the formula like it is text.....how...