Greetings
Code:
=SUMPRODUCT((ISNUMBER(SEARCH("9P to 9A",A4:A1000)))*(B4:AC1000={"K"}))
This formula counts "1" every time the string "K" is found in a range of rows which also contain another cell value "9P to 9A". Works great as far as I've found, although, it's probably a little complicated.
Now I also want this formula to search for "Km" in addition to "K".
I tried these and they didn't work:
Code:
=SUMPRODUCT((ISNUMBER(SEARCH("9P to 9A",A4:A1000)))*(B4:AC1000=OR({"K"},{"Km"}))) <<value not found error
=SUMPRODUCT((ISNUMBER(SEARCH("9P to 9A",A4:A1000)))*OR((B4:AC1000={"K"}),(B4:AC1000={"Km"}))) <<gave an incorrect result
I've attached an edited version of the workbook.
Can someone point me in the right direction?
Thank you!
I have a large spreadsheet in which I am trying to calculate the number cells
in each row with specific contents. Using the "COUNTIF()" function, I am able
to do almost all of what I want. However, I need to subtract out any cells
that have the contents formatted in Italic text. I cannot find any way to do
so. Any suggestions would be welcome.
im tryin to format a cell so that it automatically gets bigger if i type a
large amount of text.
can ne1 help?? thanx a lot
I produce a performance report each month in Excel 2003. It shows a number of graphs and charts, together with a lot of text which summarises the main incidents. My boss then has to extract some of the information in my report and a number of other staff reports into a Board Report. The board report is produced in Microsoft Word which means that copying say 20 lines of data into word is a not straightforward and has to be done one line at a time. What do I have to do to my Excel report, in order to make copying data over to Word is a lot easier. Any help is appreciated. Kevin.
I am opening a text (tab delimited) file, running a macro that copies the sheet and does some formatting. I am also trying to run a macro to Save As a Microsoft Excel Workbook but when I do I lose the original sheet and it saves it as the text (tab delimited) file instead. I need both sheets but can not get a macro to Save As a Microsoft Excel Workbook. Can someone please help me? I am on Office XP/Excel 2002
Thanks
For example, if your emailing someone a spreadsheet and you dont want them to change anything on it, how do you block or prevent the user from making changes to the document. On Microsoft Excel.
Today a company e-mailed me a quotation with the extension: xls
I don't have Excel and eventually found Excel Viewer 2003. This took 45 mins
to download, and then didn't work. The Excel File Graphic had appeared atop
the quotation file - but when clicked on Excel Viewer 2003 opened and just
said: cannot open this file type.
Any ideas? Would appreciate solution. Running XP SP2 on a Dimension 8250..
Thanks
Hi, may i know is there any setting has to be enabled when i run my 2007 excel file (hello.xls) on 2010 excel?
The macro in this file can run smoothly when i open it with microsoft excel 2007. Yet, when i tried to open my file with microsoft excel 2010, an error msg state that my file is not being supported my microsoft excel 2010.
I have a function
Code:
Private Declare Function SetTimer Lib "user32"
in my macro.. i wonder is it becoz of this my file is not being supported.. but i have google that excel 2010 does support 32 and 64.
Please advise... Thank u very much
Count Only the Text Cells within a List