Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif OR Sumproduct- I NEED HELP
HI,
I need a formula to create I need to count number of items in #SHEET1 $B:$B if VALUE in #Sheet1 $A:$A matches #SHEET2 $A3. Please Help Me. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif OR Sumproduct- I NEED HELP
Try this:
=COUNTIF(Sheet1!$A:$A,Sheet2!$A3) Not sure what criteria, if any, you have for column B. Hope this helps. Pete On Mar 4, 12:28*pm, dareal wrote: HI, I need a formula to create *I need to count number *of *items in #SHEET1 $B:$B *if VALUE in #Sheet1 $A:$A matches *#SHEET2 $A3. Please Help Me. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif OR Sumproduct- I NEED HELP
If you just need a count then a very simple
=COUNTIF(Sheet1!$A:$A=Sheet2!$A$3) will do it. But if you need a total of quantities in B on Sheet1 based on the match of A3 to A:A on sheet 1, then =SUMIF(Sheet1!$A:$A,"=" & Sheet2!$A$3, Sheet1!$B:$B) "dareal" wrote: HI, I need a formula to create I need to count number of items in #SHEET1 $B:$B if VALUE in #Sheet1 $A:$A matches #SHEET2 $A3. Please Help Me. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif OR Sumproduct- I NEED HELP
Oops, the COUNTIF() formula should have been
=COUNTIF(Sheet1!$A:$A, Sheet2!$A$3) "JLatham" wrote: If you just need a count then a very simple =COUNTIF(Sheet1!$A:$A=Sheet2!$A$3) will do it. But if you need a total of quantities in B on Sheet1 based on the match of A3 to A:A on sheet 1, then =SUMIF(Sheet1!$A:$A,"=" & Sheet2!$A$3, Sheet1!$B:$B) "dareal" wrote: HI, I need a formula to create I need to count number of items in #SHEET1 $B:$B if VALUE in #Sheet1 $A:$A matches #SHEET2 $A3. Please Help Me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT OR COUNTIF | Excel Worksheet Functions | |||
COUNTIF/SUMPRODUCT?? | Excel Worksheet Functions | |||
SumProduct & Countif? | Excel Worksheet Functions | |||
COUNTIF or SUMPRODUCT? | Excel Worksheet Functions | |||
SUMPRODUCT/COUNTIF | Excel Discussion (Misc queries) |