Counting Question
 

This is probably a simple solution, but I am drawing a blank.

I need to count based on two criteria.

Count the number of times 'SKU Data'!A:A=B16 and 'SKU Data'!D:D=L23

Help Please

Counting Question
 

use countif()

-John

"rlee1999" wrote:

This is probably a simple solution, but I am drawing a blank.

I need to count based on two criteria.

Count the number of times 'SKU Data'!A:A=B16 and 'SKU Data'!D:D=L23

Help Please

Counting Question
 

Add a little to my last post, something like
=countif('SKU Data'!A:A,B16)+countif('SKU Data'!D:D,L23)

-John

"rlee1999" wrote:

This is probably a simple solution, but I am drawing a blank.

I need to count based on two criteria.

Count the number of times 'SKU Data'!A:A=B16 and 'SKU Data'!D:D=L23

Help Please

Counting Question
 

=SUMPRODUCT(--(A1:A100000=B16),--(B1:B100000=L23))

"rlee1999" wrote:

This is probably a simple solution, but I am drawing a blank.

I need to count based on two criteria.

Count the number of times 'SKU Data'!A:A=B16 and 'SKU Data'!D:D=L23

Help Please

Counting Question
 

This is giving me a #NAME? Error, any ideas?


"Duke Carey" wrote:

=SUMPRODUCT(--(A1:A100000=B16),--(B1:B100000=L23))

"rlee1999" wrote:

This is probably a simple solution, but I am drawing a blank.

I need to count based on two criteria.

Count the number of times 'SKU Data'!A:A=B16 and 'SKU Data'!D:D=L23

Help Please

Counting Question
 

Hi John,

This is giving me a value of 64, which is the number of rows that contain
the value in B16 and seems to be ignoring the second countif function.
Otherwise it would be returning a value of 84, which is the 64 it is
returning + the 20 rows that contain the value from L23. Any ideas on how to
count rows where only the two criteria both occur?

"John Bundy" wrote:

Add a little to my last post, something like
=countif('SKU Data'!A:A,B16)+countif('SKU Data'!D:D,L23)

-John

"rlee1999" wrote:

This is probably a simple solution, but I am drawing a blank.

I need to count based on two criteria.

Count the number of times 'SKU Data'!A:A=B16 and 'SKU Data'!D:D=L23

Help Please

Counting Question
 

Not without a workaround, The formula I gave works fine for me, can you try
to do a countif for one criteria in one column and a countif for the other
criteria in another column? if they both work then you should be able to add
a "+" and paste one on the end of the other

-John

Counting Question
 

try

=SUMPRODUCT(--('SKU Data'!A1:A100000=B16),--('SKU Data'!B1:B100000=L23))