Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

countif,vlookup,subtotal, VB script

Status
Not open for further replies.
ratman

ratman

Technical User
Jun 26, 2000
143
US
Received a great countif from you fine people the other day that when placed in column H (Panels)<br>=(COUNTIF(G2,&quot;&lt;&gt;0&quot;))*40<br>and manually(blah) copied down tested if column G (Pieces) had non-zero's to multiply it by 40.<br><br>My boss says:<br>The sheet ultimately needs to be sorted by column D (Department).&nbsp;&nbsp;Then only applying the countif&nbsp;&nbsp;(shown above) if column D contains a department name listed in the vlookup table located in column K.&nbsp;&nbsp;&nbsp;Then subtotaled (using SUM) for every change in column D (Department), results summary placed below data in column G (Panels) and column H (Pieces). <br><br>
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
whats wrong with Vlookup 2
2
Replies
20
Views
352
SkipVought
S
Cpreston
  • Locked
  • Question
vlookup issue 1
Replies
4
Views
128
combo
combo
wmbb
  • Locked
  • Question
Why does VLOOKUP work and MATCH function gives #NA 1
Replies
6
Views
190
wmbb
wmbb
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
1K
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
COUNTIF() with spaces 2
Replies
10
Views
590
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top