Multiplying countif text matches within a range

[Gouldinho83]

Hi All,

On the attached file, in the 'stock control' tab, in total stock added table I have added a counter to record each time a stock type is chosen from the drop down lists in the first 2 tables, but cannot work out how to multiply that by the quantities entered in the next column. I've put some numbers in for 'Sensor Controller' as an example, where there have been 2 orders of 20 received and 2 units returned to stock. This should mean I have 42 units of 'sensor controller' in stock, however with my very limited knowledge of using these I can only seem to make it recognise each entry as 1.

I hope this all makes sense. Also, last time I posted a similar problem, somebody just completely did it for me - which was great, however I'm also hoping that someone could point me to some resource whereby I can learn to implement this myself next time!

Many Thanks in Advance!

[davsth]

its better as 2 sumifs
=SUMIF($C$3:$C$25,K3,$D$3:$D$25)+SUMIF($H$3:$H$25,K3,$I$3:$I$25)

https://www.excelforum.com/tips-and-tutorials/ on this site is a good start to learn a bit more, or just reading other peoples posts and solutions. Here you are wanting to sum if something is true instead of count, you were only one step away

[Gouldinho83]

Thanks davsth yes works well you're right. I'm just trying to pick that line of code apart to understand what you've done. The only part I can't work out is where you've told it only to multiply entries across a single row. Also is there anywhere you would recommend for me to learn these things? It doesn't strike me as something I'd find particularly difficult to pick up, just a case of gaining that initial understanding!

[Gouldinho83]

Ignore that part about the learning, I was so excited by your line of code that I did not read the next part!