Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need your help with formulas in excel!!
I have 2 columns one for type and one for physical. I need to count how many
total but only the counting those that are typed as "ofc" AND with the physical as "vacant". I have no idea how to do this PLEASE HELP!! -- michelle |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need your help with formulas in excel!!
Hi,
Does this work for you? =SUMPRODUCT((A1:A9="ofc")*(B1:B9="vacant")) Mike "michelle wilson" wrote: I have 2 columns one for type and one for physical. I need to count how many total but only the counting those that are typed as "ofc" AND with the physical as "vacant". I have no idea how to do this PLEASE HELP!! -- michelle |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need your help with formulas in excel!!
Use an array formula {=SUM(IF(A1:A30="Vacant",IF(B1:B30="ofc",1,0),0))} Enter the sum formula as you normally would, and adjust the ranges according to your needs. To get the brackets around the formula, hold down <Ctrl, <Shift, <Enter. -- HTH JonR "michelle wilson" wrote: I have 2 columns one for type and one for physical. I need to count how many total but only the counting those that are typed as "ofc" AND with the physical as "vacant". I have no idea how to do this PLEASE HELP!! -- michelle |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need your help with formulas in excel!!
Yes it did - now if I also need to include I2-I28 = OFC AND H2-H28=VACANT. I
TOOK A WHACK AT ADDING IT BUT I DIDN'T DO SOMETHING RIGHT. UUGGHHH - THANK YOU SO MUCH FOR YOUR HELP! -- michelle "Mike H" wrote: Hi, Does this work for you? =SUMPRODUCT((A1:A9="ofc")*(B1:B9="vacant")) Mike "michelle wilson" wrote: I have 2 columns one for type and one for physical. I need to count how many total but only the counting those that are typed as "ofc" AND with the physical as "vacant". I have no idea how to do this PLEASE HELP!! -- michelle |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need your help with formulas in excel!!
=SUMPRODUCT((I2:I28="OFC")*(H2:H28="Vacant"))
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "michelle wilson" wrote in message ... Yes it did - now if I also need to include I2-I28 = OFC AND H2-H28=VACANT. I TOOK A WHACK AT ADDING IT BUT I DIDN'T DO SOMETHING RIGHT. UUGGHHH - THANK YOU SO MUCH FOR YOUR HELP! -- michelle "Mike H" wrote: Hi, Does this work for you? =SUMPRODUCT((A1:A9="ofc")*(B1:B9="vacant")) Mike "michelle wilson" wrote: I have 2 columns one for type and one for physical. I need to count how many total but only the counting those that are typed as "ofc" AND with the physical as "vacant". I have no idea how to do this PLEASE HELP!! -- michelle |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need your help with formulas in excel!!
Hi,
When you say "I also need to include I2-I28 = OFC AND H2-H28=VACANT" Do you mean that you now have 2 different ranges? One range in Columns A and B, and another inColumns H and I? Dave. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need your help with formulas in excel!!
exactly. For instance I have B2-B28 and H2-H97 for OFC and then C2-C28 and
I2-I97 for VACANT. Thank you again! -- michelle "Dave" wrote: Hi, When you say "I also need to include I2-I28 = OFC AND H2-H28=VACANT" Do you mean that you now have 2 different ranges? One range in Columns A and B, and another inColumns H and I? Dave. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need your help with formulas in excel!!
Hi Michelle,
Then I think it's just a matter of adding them together: =SUMPRODUCT((B2:B28="ofc")*(C2:C28="vacant"))+SUMP RODUCT((H2:H97="ofc")*(I2:I97="vacant")) All on one line, of course. Regards - Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
Excel Formulas | Excel Worksheet Functions |