| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Question
try
=SUMPRODUCT(--('SKU Data'!A1:A100000=B16),--('SKU Data'!B1:B100000=L23)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 Counting occurrances | Excel Discussion (Misc queries) | |||
| Counting Question | Excel Discussion (Misc queries) | |||
| Counting Question | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Counting question | Excel Discussion (Misc queries) | |||
Linear Mode
