## Questions about my Excel works

Hi! I study use of Excel in my university, but I’ve encountered insurmountable challenge in my latest homework. No previous teaching material or …

## countifs or sumif?

I am tracking items taken from inventory. At any given time we take out tshirts and distribute to branches.  I need to provide totals of all sizes distributed …

## Dynamic cell reference in countif function

I have a spreadhseet holding a list of grade 1 learners. Obviously the number of learners can vary over time. I am using an array formula to find the reference …

## IF Function Including Count Colour

I was able to count cells by their background color by the following: Function CountColour(rng As Range, clr As Range)Dim c As RangeFor Each c In …

## Convert SUMIFS Function To Excel 2003

Hi, hope you can help, I want to convert the formula below to a workable one in 2003 version. I’m aware that 2003 does not support the sumifs fiunction …

## Automatically Pull Data from Master Sheet

I have a spread sheet with 5 sheets, sheet (SH)1 is the master sheet, sheets 2, 3, 4 & 5 are different routes, on the master sheet i have 4 columns, col1 …

## Using Excel’s MIN Function

To quickly find the minimum number in a range of cells you can use Microsoft Excel’s MIN Function that will quickly tell you the minimum number from a …

## Adding a column in a IF function

i have an overview page. i need to add an entire column from a differant sheet if it says a certain word. the column will have 4 differant words i need to add …

## Using Excel’s COUNTIFS Function

A new function for Excel 2007, the COUNTIFS function returns the number of cells (of a specified range), that match a set of given criteria. So let’s say …

## Count the Number of Cells in a Range based on Criteria

In a previous post I talked about how to use the COUNT function in Excel to count the number of cells containing data.  Well, you can also combine COUNT with …

## Counting Cells in a Range using Count Function

When using Excel, it’s often beneficial to know how many cells that contain data there are in a range.  A real easy to work this out is using the COUNT …