counif

Hi all, i have rainfall data for 3 years. I want a formula that can give me the day of the month once total rainfall from 01 Jan is equal to 51...

Hi all, I am new to this so bare with me. Below is the current solution to my predicament, done manually. I would like to automate the distribution column. For this, the numerator is the TVU column, and the denominator is determined via the COUNTIF() function. The issue is that I cannot get...

I am looking to count the number of times the event took place in January (1) or December (12). I custom displayed the month to just 'mm' and used the formula =countif('Driver Data'!AO:AO,"01") for January or =countif('Driver Data'!AO:AO,"12") for December Any ideas?

Hi, I have a big table where I need a formula to do the following: if six cells in a column contain the same value, the formula should return "yes" Example: <colgroup><col></colgroup><tbody> column N Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles Los Angeles...

Hi Everyone I currently have a pivot table with following information: <tbody> Row A B 1 Area Path Count of ID 2 \Bails and Hearings\Bails 20 3 \Bails and Hearings\Court Hearing 9 4 \Case Management\Case History 3 </tbody> I need a formula to count all the items in the...

I am creating multiple macro function workbook. Below formula is required for full fill my macro. Please provide Macro VB code for below Excel formula This formula is populate in sheet name "Worksheet 1" vlookup with "Worksheet 2" =IF(COUNTIF(A1:$A$5000,A1)=1,VLOOKUP(A1,'Worksheet...

Hi i have xl file that contains a two tables of data. (see below) One table contains the names of some datahubs and the other contains sites that connects to the hubs. Wat i would like to do is to Count the number of sites each datahub has and store that value so it could be reused for other...

ok have a sheet that is smart filtered by a equiments location. and the b collum is data validated with a drop down box. I am trying to make a countif formula to count the number of equipment at the possible locations. should be something like this =countif(b3:B62,FRH) =countif(b3:B62,VIC)...