| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
State Tax Business Calculations Help
Urgg.. I've been trying to figure out this one for days and it's eating my lunch.. What I need F20 to do is this:
If B2:B10 does not contain the abbreviation "OK" And H2:H10 does not have a dollar amount in it then add the total of G2:G10 (B2:B10,"<ok",H2:H10,"=0",G2:G10) attached is my excel spreadsheet |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
State Tax Business Calculations Help
Hi Kathy,
Am Fri, 10 Jan 2014 14:10:07 +0000 schrieb KathyP143: (B2:B10,"<ok",H2:H10,"=0",G2:G10) try: =SUMPRODUCT(--(B2:B10<"ok"),--(H2:H10=0),G2:G10) Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replace state names with state code abbreviations | Excel Worksheet Functions | |||
| Calculating 10 Business Days from the Last Business Day of the Mon | Excel Worksheet Functions | |||
| How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
| Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
| WHERE CAN I GET A BUSINESS PROPOSAL OR A BUSINESS EXPENSE SHEET? | New Users to Excel | |||
Linear Mode
