«

J.E. McGimpsey wrote:

> Simply: Compare each cell in Sheet "Audit Report", cells C2:C2001
> with the value in cell A4 in the sheet the formula is entered in.
> the returned value is the sum of Sheet "Audit Report", cells
> I2:I2001 for which the comparison with their corresponding cell in
> column C was TRUE.


> "Brian Tozer" <> wrote:

>> Could some kind person please tell me in words exactly what the
>> following formula found in cell C4 means/does?
>> And what it may be assuming or requiring elsewhere to function
>> correctly. In use the cell has a quantity (number of items) entered
>> in it.
>>
>> =SUMIF('Audit Report'!C$2:C$2001,A4,'Audit Report'!I$2:I$2001)


While I appreciate very much the above response to my query I am still
unclear as to exactly what it means in practice.
Should I post my specific queries on the possible interpretations that I
see, or can you/anyone rephrase it hoping that the extra description will
remove my confusion?
Possibly including an example with data entries?

Sorry to be a nuisance, but I am making progress in the upskilling process,
even if it doesn't show.... ))

Thanks
Brian Tozer

In article <bqlr6h$1ma$>, "Brian Tozer" <> wrote:
(snip)
>Sorry to be a nuisance, but I am making progress in the upskilling process,
>even if it doesn't show.... ))

Suggest looking at these groups
microsoft.public.excel
microsoft.public.excel.misc

for xl help. They are terrific. There are (IIRC) others more
specialised if you need that. Well worth a look.

HTH

Bruce

-----------------------------------------------------------------------
It was so much easier to blame it on Them. It was bleakly depressing to
think that They were Us. If it was Them, then nothing was anyone´s fault.
If it was Us, what did that make Me ? After all, I´m one of Us. I must be.
I´ve certainly never thought of myself as one of Them. No-one ever thinks
of themselves as one of Them. We´re always one of Us. It´s Them that do
the bad things. <=> Terry Pratchett. Jingo.

"Brian Tozer" <> wrote in message
news:bqlr6h$1ma$...

> >> Could some kind person please tell me in words exactly what the
> >> following formula found in cell C4 means/does?
> >> And what it may be assuming or requiring elsewhere to function
> >> correctly. In use the cell has a quantity (number of items) entered
> >> in it.
> >>
> >> =SUMIF('Audit Report'!C$2:C$2001,A4,'Audit Report'!I$2:I$2001)
>
>
> While I appreciate very much the above response to my query I am still
> unclear as to exactly what it means in practice.

Clippy isn't just a pretty face!

SUMIF(range,criteria,sum_range)
Range is the range of cells you want evaluated.
Criteria is the criteria in the form of a number, expression, or text that
defines which cells will be added. For example, criteria can be expressed as
32, "32", ">32", "apples".
Sum_range are the actual cells to sum. The cells in sum_range are summed
only if their corresponding cells in range match the criteria. If sum_range
is omitted, the cells in range are summed.


In practice, this means that the spreadsheet will search the "Audit Report"
worksheet
cells C2 to C2001 for whatever is in the cell "A4".

It will then add the cell contents of "I2" to "I2001" for any instances of
"A4".

ie: if A4 is Cat, C2 is Cat and I2 is 5. If there are no more instances of
Cat the sum will be 5 (the number of cats in the range).

As an added indicator if you click in the formula bar, you will see the
formula cells change colour to whatever ranges they are depicting. You can
then drag, stretch drop them to any location you want.

HTH.

--
Mr Scebe
Losers always whine about their 'best'.
Winners go home and **** the prom queen".
~Sean Connery in "The Rock

Mr Scebe wrote:

> As an added indicator if you click in the formula bar, you will see
> the formula cells change colour to whatever ranges they are
> depicting. You can then drag, stretch drop them to any location you
> want.

Thanks very much for your very helpfull reply.
Could you enlarge a little on the above comment, or tell me what I should
look for in the Help or Google for further info on this
aspect/operation/facility/feature.

Brian Tozer