sumif and countif

I have encountered additional issues and need help from the experts. X2 should only total if there are more than 1 instance of Recipe 1 used in a single day. This is determined in column J O55 should be 0 because there was only 1 Recipe 1 used that day. I would like to change that from using...

Hi everyone, Sorry but I can't get my head around this - I have created a workbook with a number of sumif & countif functions. However, I didn't realize that they don't work if the sheet that they are refering to are closed! I can't keep all the files open as there is way too much info. I...

I am trying to figure out how to search a range of cells (F8:F300) for a name (B8), for multiple occurences, and everytime the name is found, take the value from the adjacent cell in column I, and sum it up. Example G H I Name1 X .5 Name2 Y 1 Name1 Z 1 Name3 X .5 Name1 Y 2 Find all the...

Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have been trying to figure out a way to do this, and so far have failed miserably. I can't seem to develop an array function that works, and my VBA is not up to scratch enough to create...

I am fairly new to Excel, I need the sum of a dollar amount in column B, but only if the month in column E = 11, and only if the category in column D = "T". I basically want to know the sum of the "T" in the month of November. For example: 10/18/09 $134.00 CH T 10 10/18/09 $250.00 CH O 10...

A B 10 135 10 19 10 15 10 16 11 27 11 19 11 230 11 152 11 37 12 56 12 99 What I am trying to do is add all the numbers in column B if the numbers in column A are the same. For example A1 to A4 are the same so I want to add B1to B4. A5 to A9 are the same so I want to add B5 to B9, etc. My...