Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Formula To Use
I have a Workbook And I dont know what Formula To Use Ive Tried DCOUNT And
SUM Product and Others Some One Help me out UNIT Date to BN Status 205TH MI N/A G-1 A CO 1-68 11feb06 Complete B CO 1-68 N/A G-1 A CO 1-68 11 OCT BN C CO 1-68 Na G-1 Example of what I want to do is--- IF Unit Equals A CO 1-68 then Count how Many Are G-1 So with this I would Get 1 Any one Can Help Me???? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Formula To Use
=SUMPRODUCT((A2:A6="A CO 1-68")*(C2:C6="G-1"))
HTH -- AP "CERYD" a écrit dans le message de news: ... I have a Workbook And I dont know what Formula To Use Ive Tried DCOUNT And SUM Product and Others Some One Help me out UNIT Date to BN Status 205TH MI N/A G-1 A CO 1-68 11feb06 Complete B CO 1-68 N/A G-1 A CO 1-68 11 OCT BN C CO 1-68 Na G-1 Example of what I want to do is--- IF Unit Equals A CO 1-68 then Count how Many Are G-1 So with this I would Get 1 Any one Can Help Me???? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Formula To Use
Say you have ="A CO 1-68" in D1 and "G-1" in E1, you can write:
=SUMPRODUCT((A2:A6D1)*(C2:C6=E1)) HTH -- AP "Ardus Petus" a écrit dans le message de news: ... =SUMPRODUCT((A2:A6="A CO 1-68")*(C2:C6="G-1")) HTH -- AP "CERYD" a écrit dans le message de news: ... I have a Workbook And I dont know what Formula To Use Ive Tried DCOUNT And SUM Product and Others Some One Help me out UNIT Date to BN Status 205TH MI N/A G-1 A CO 1-68 11feb06 Complete B CO 1-68 N/A G-1 A CO 1-68 11 OCT BN C CO 1-68 Na G-1 Example of what I want to do is--- IF Unit Equals A CO 1-68 then Count how Many Are G-1 So with this I would Get 1 Any one Can Help Me???? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Formula To Use
I already gave you answer with both sumproduct and dcounta yesterday, if you
don't understand it you should post in the same thread with what didn't work etc -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "CERYD" wrote in message ... I have a Workbook And I dont know what Formula To Use Ive Tried DCOUNT And SUM Product and Others Some One Help me out UNIT Date to BN Status 205TH MI N/A G-1 A CO 1-68 11feb06 Complete B CO 1-68 N/A G-1 A CO 1-68 11 OCT BN C CO 1-68 Na G-1 Example of what I want to do is--- IF Unit Equals A CO 1-68 then Count how Many Are G-1 So with this I would Get 1 Any one Can Help Me???? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Formula To Use
Here is how a DCOUNTA would look like
=DCOUNTA(A5:C10,"Status",F1:G2) where F1 holds UNIT, G1 holds Status, F2 holds A CO 1-68 and G2 holds G-1 and A5:C10 is the example table, however unless your example got scrambled up when you posted it then I can't see how you would get 1 from that, I get zero since there is now row where both A CO 1-68 and G-1 occur -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Peo Sjoblom" wrote in message ... I already gave you answer with both sumproduct and dcounta yesterday, if you don't understand it you should post in the same thread with what didn't work etc -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "CERYD" wrote in message ... I have a Workbook And I dont know what Formula To Use Ive Tried DCOUNT And SUM Product and Others Some One Help me out UNIT Date to BN Status 205TH MI N/A G-1 A CO 1-68 11feb06 Complete B CO 1-68 N/A G-1 A CO 1-68 11 OCT BN C CO 1-68 Na G-1 Example of what I want to do is--- IF Unit Equals A CO 1-68 then Count how Many Are G-1 So with this I would Get 1 Any one Can Help Me???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |