Summing by Attribute (Excel 2000)

Topic

New Reply

I have a need to create a spreadsheet that has one column with a Code (can vary from RT-01 to RT27)
and a second column that has the Quantity assigned to that code. There can be multiple entries for
a specific date and quantity is variable from 1 up. To the right of this, I have a column that shows all
possible Codes (RT-01 through RT-27) and to the right of that I would like to generate a column that
shows the number of entries for that code. I could use IFCOUNT to count the number of entries for a
code, but if the quantity is other than 1 that doesn’t work. Any thoughts appreciated.

See attached file for example of what I need

Reply | Quote

Replies

It looks like you want the frequency of occurrence of a given code in the range $C$3:$C$111…

In F4 enter & copy down:

=COUNTIF($C$3:$C$111,E4)

If you want the total qty per code, use…

=SUMIF($C$3:$C$111,E4,$B$3:$B$111)

Aladin

Reply | Quote

The SUMIF formula is exactly what I needed.

Thanks
Thomas Cox

Reply | Quote