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))