Okay. I learned a thing or two but still not working for me. Sheet 1 looks like this Monday Tuesday Wednesday Etc... John Smith...

I have a spreadsheet that contains the following data: Date Account...

I use this formula: =COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40) I would like to change the formula so that it will use the value in cell A1 (eg 200) like...

I have a spreadsheet that contains the following data: Date Account...

Why is that my answer to my formula will not update? It was working fine at first not it do not. I want to count text in each cell (eg. A5-A9). The formula I...

I have tried all avenues but to no availe and require assistance urgently please. The formula I require has to in Worksheet A :- lookup DATA in Worksheet...

using this formula =SUMPRODUCT(H18:H103,--(TEXT(B18:B103,"yyyymm")=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+0,1),"yyyymm"))) when column E is mark with "X", i...

Hi How do i add tick mark in excel sheet?i know its in symbol but i want to prepare yes or no tick mark...

I need the functionality of COUNTIFS but for Excel 2002. I don't want to sum but rather count. Below is the formula I would use if I had the COUNTIFS...

I have one worksheet of all the people invited to an event. One column indicates y for they're coming, n for they're not and blank if they have not yet...

This is the 3rd time I am posting...is this visible?: Also, why can't I find questions I posted? -- I am having a problem with time sheet reporting. We...

using this formula =SUMPRODUCT(H18:H103,--(TEXT(B18:B103,"yyyymm")=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+0,1),"yyyymm"))) when column E is mark with "X", not...

I have a worksheet that uses custom formulas on several inputs from that page. I've used it for a while and never had a problem, but made some changes...

I need to check the values of two columns agains another two colums (with same data) and if they are both in the sheet return a positive result, or if wrong...

What is the problem with the array formula (see cells in column R, which are highlighted coloured yellow)...

Hi. I use this formula: =COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40) I would like to modify it so that the value I put in Cell A1 (eg 100) will change the formula...

Hi I have a bit of a problem I'm hoping someone can help with. Not sure if what I want to do is possible within Excel so any help would be gratefully...

Hi I am trying to search within Excel VBA a value in a sheet dependant on the entry in another cell. But not sure how to put a paramater as the What part of...

Hello, I'm trying to count unique numbers in a resulting list after filtering. I have already learned how to count unique number in an unfiltered list...

Hi, In cell A1 I have the following information: Fri 30 Oct 09:11 What I would like to do, via a macro I imagine, is to delete the month and to seprate out...