Count the number of items sold in one column based on the quantity in another column

**mike_m1** · 08-16-2013, 12:13 PM

I am trying to count the number of items sold in one column based on the value in another column.
For example: Column A shows numbers sold and Column B is the day they were sold on, how do I get column C to show me the combination of the two?

Column A Column B Column C
2 Wednesday 3
1 Wednesday
3 Thursday 6
3 Thursday
2 Friday 4
2 Friday

Many thanks

**Naveed Raza** · 08-16-2013, 12:42 PM

if possible can u please attached sample excel workbook

**mike_m1** · 08-16-2013, 01:03 PM

Example attached.

Thanks

**Naveed Raza** · 08-16-2013, 01:59 PM

now try this attached file

**mike_m1** · 08-19-2013, 01:16 PM

Is there an alteration we could make to the formula if on some days there were 6 references and on other 1 and to have the total placed alongside the first instance, even if there are 5 Saturdays or 1 Monday?

Many thanks

**Ace_XL** · 08-19-2013, 01:20 PM

In C1

=IF(COUNTIF($B$1:B1,B1)>1,"",SUMIF($B$1:$B$6,B1,$A$1:$A$6))

Copy down.

**mike_m1** · 08-19-2013, 01:37 PM

Thanks for that, does that formula assume there are 6 row entries? What would need to change if this was to be 35 rows?

Many thanks

**Ace_XL** · 08-19-2013, 01:42 PM

does that formula assume there are 6 row entries? What would need to change if this was to be 35 rows?

Yes..change ranges accordingly

In C1
=IF(COUNTIF($B$1:B1,B1)>1,"",SUMIF($B$1:$B$35,B1,$A$1:$A$35))
Copy down

**Naveed Raza** · 08-19-2013, 11:24 PM

if you got your solution then please don't forget click on ADD REPUTATION and mention your valuable comments for us and mark this thread as SOLVED

**mike_m1** · 08-20-2013, 05:48 AM

Excellent, thank you guys, you have solved me query with great clarity.

Many thanks

Count the number of items sold in one column based on the quantity in another column

LinkBack

Thread Tools

Rate This Thread

Display

Count the number of items sold in one column based on the quantity in another column

Re: Count the number of items sold in one column based on the quantity in another column

Re: Count the number of items sold in one column based on the quantity in another column

Re: Count the number of items sold in one column based on the quantity in another column

Re: Count the number of items sold in one column based on the quantity in another column

Re: Count the number of items sold in one column based on the quantity in another column

Re: Count the number of items sold in one column based on the quantity in another column

Re: Count the number of items sold in one column based on the quantity in another column

Re: Count the number of items sold in one column based on the quantity in another column

Re: Count the number of items sold in one column based on the quantity in another column

Thread Information

Users Browsing this Thread

Similar Threads

Need Macro to duplicate cells in Column A based off quantity and cell value in Column B

[SOLVED] Count the number of items in a column that are equal to another column's #'s in same row.

[SOLVED] count the number of populated cells in column N based on data in column D

How to Update Stock quantity if I sold items?

[SOLVED] Count number of items in one column that have a value in another?

Bookmarks

Bookmarks

Posting Permissions