Help Counting items based on category

[Dandrewhill]

Hi,

Thank you in advance!

I need to count how many of a category to get a total.

This is for transport and logistic spreadsheet.

I had 'X' amount of 'pallet type' come in on a range of different days. I want to know the total amount of 'pallet type' that has come in.

Please see screen shot below:spreadsheet.jpg

Thanks very much!

Dan

[Tony Valko]

Something like this...

A1 = Chep Timber

=COUNTIF(E:E,A1)

[Pete_UK]

Use this:

=SUMIF(E:E,"Chep Timber",C:C)

or, if you put Chep Timber in a cell somewhere (e.g. M2) and Locsam Timber in M3, then you can have this formula in N2:

=SUMIF(E:E,M2,C:C)

and copy it down.

Hope this helps.

Pete

[Dandrewhill]

Thanks Pete,

I have now tried both of your suggestions, but I am receiving a error about circular references and it is returning a '0'....

do you know what I am doing wrong?

Cheers,

Dan

[Pete_UK]

Ensure that the formula is not placed within column E or column C, as it is using full-column references.

Hope this helps.

Pete

[Dandrewhill]

Thanks Pete!

Solved!

Many Thanks,

Dan