Counting Instance on One Sheet and Returning the Number on Another Sheet

[Tuffman]

I need help in writing the VBA code that will do the following:

• On Cars Database worksheet, search through column A for Toyota
• When Toyota is found, for the condition of Toyota and Black, count the number of 4-Runners
• Display/paste that number in cell A3 on Sheet2

Any help would be appreciated.

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’).

If you have Excel 2016 or newer, you should be able to do this pretty easily with a COUNTIFS formula.
See here an explanation and examples of how to use this function: COUNTIFS function - Microsoft Support

 

[alansidman]

If you have the latest version of Excel 365 Insider Beta, then you can use the GroupBy function.
or
You can Group the results using Power Query.

Additionally, Cannot manipulate data in a picture. Re post using MrE XL2BB function.