ExcelBanter - Excel Query

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Query (https://www.excelbanter.com/excel-discussion-misc-queries/208082-excel-query.html)

dave230

Excel Query

I have a worksheet and I would like to query and count the number of records
by looking at 2 different colums and picking those records which contain the
required data in both.

Sheeloo[_3_]

Excel Query

=SUMPRODUCT(--(A1:A100="Something in Col A"),--(B1:B100="Something in B"))

Change 100 to last row in your data set and conditions to what you want or a
cell reference.

"dave230" wrote:

I have a worksheet and I would like to query and count the number of records
by looking at 2 different colums and picking those records which contain the
required data in both.

All times are GMT +1. The time now is 11:44 AM.