Counting the number of times an item was sold but only if it has been paid for

**JustMike** · 04-26-2019, 02:30 PM

I'm trying to count the number of times an individual item was sold by using countif. I have a countif formula which returns all the times the items were used in the table but now I want it to only count them if the corresponding cell in the paid? column returns true.

unfortunately I am not able to show pictures of this or use any link to help solve my problem so sorry if my description is lacklustre and please feel free to ask me any questions

thank you for the help,

Michael

**JustMike** · 04-26-2019, 02:31 PM

I guess it lets me submit images through a reply though...

Attachment 621731

Attachment 621732

**Pete_UK** · 04-26-2019, 02:33 PM

You can use COUNTIFS with 2 criteria - one criterion is the item, the other criterion is if the paid column is TRUE.

Hope this helps.

Pete

**JustMike** · 04-26-2019, 02:51 PM

Originally Posted by Pete_UK

You can use COUNTIFS with 2 criteria - one criterion is the item, the other criterion is if the paid column is TRUE.

Hope this helps.

Pete

thanks Pete, I did try this but it just came up with an error

**Sam Capricci** · 04-26-2019, 03:00 PM

What Pete mentioned should work, I know I can't open either of your attachments, when I click on them I get an "invalid attachment" note. You should be able to set up a small representative sample workbook WITH expected results and upload it using the "Go Advanced" button under this window. Then scroll down and click on the blue "manage attachments" and it will open a window for you to browse to the workbook and upload it, then close the window and submit reply.

**JustMike** · 04-26-2019, 05:05 PM

Alright, I hope this has worked. to repeat my question again for clarity, I am trying to only get the names to count when the corresponding Paid? column is true.

Thank you

**Sam Capricci** · 04-26-2019, 09:16 PM

this is one way...
=COUNTIFS($G$6:$G$21,C7,$F$6:$F$21,TRUE)+COUNTIFS($H$6:$H$21,C7,$F$6:$F$21,TRUE)+COUNTIFS($I$6:$I$21,C7,$F$6:$F$21,TRUE)+COUNTIFS($J$6:$J$21,C7,$F$6:$F$21,TRUE)
I know there is an easier way but I'm working from the iMac version of excel which isn't as flexible as excel for PC.

**bebo021999** · 04-26-2019, 10:21 PM

Try SUMPRODUCT:

Please Login or Register  to view this content.

**JustMike** · 04-27-2019, 10:15 AM

Thank you for you're replies, Sambo kid and bebo021999. Both of your solutions worked but the sumproduct is more efficient so ill be using that.

Thank you again

Counting the number of times an item was sold but only if it has been paid for

LinkBack

Thread Tools

Rate This Thread

Display

Counting the number of times an item was sold but only if it has been paid for

Re: Counting the number of times an item was sold but only if it has been paid for

Re: Counting the number of times an item was sold but only if it has been paid for

Re: Counting the number of times an item was sold but only if it has been paid for

Re: Counting the number of times an item was sold but only if it has been paid for

Re: Counting the number of times an item was sold but only if it has been paid for

Re: Counting the number of times an item was sold but only if it has been paid for

Re: Counting the number of times an item was sold but only if it has been paid for

Re: Counting the number of times an item was sold but only if it has been paid for

Thread Information

Users Browsing this Thread

Similar Threads

Find total # of each item sold and average cost of item across multiple worksheets

Auto decrease quantity of an item when the item is sold.

[SOLVED] The number of times this product sold monthly

Counting the number of times an item appears & then copy that selection to another sheet

Counting how many times each item appearss in a Column

[SOLVED] Counting # of Times an Item Shows Up in a Table

Counting the Number of Unique Items Sold by Each Salesperson

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions