| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Array Formula
I am trying to create a formula as per the excel help "Add numbers based on
multiple conditions" I have typed a similar formula into a spreadsheet and are getting a #N/A error? The data that i am using has been exported from SAP into excel, is it because it may be in a text format? I have tried to convert this using the text to columns function, but still no joy. The formula is =SUM(IF((YTD!$A$5:$A$5989="R02")*(YTD!$H$5:$H$5989 ="81310110"),YTD!$G$5:$G$5989)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count number of dates in an array | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Will an Array Formula work here? | Excel Discussion (Misc queries) | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
