if and sumifs

[cloughie]

Does anyone have the solution to the sumifs problem i have?

=SUMIFS('Import Infomation'!$F:$F,'Import Infomation'!$E:$E,("*"&February!$A3&"*"),'Import Infomation'!$B:$B,B$2)

'Import Infomation'!$F:$F is my quantity

'Import Infomation'!$E:$E is the range for the product code

("*"&February!$A3&"*") is the criteria for the product code

'Import Infomation'!$B:$B is the date range of the product ordered

B$2 is the date criteria


What i need to do in addition to this, is to have an IF statement that tells me if the product has a gross value of 0 then not to count it within the SUMIFS

Any suggestions?

 

[Gerald Higgins]

Maybe something like this

=SUMIFS('Import Infomation'!$F:$F,'Import Infomation'!$E:$E,("*"&February!$A3&"*"),'Import Infomation'!$B:$B,B$2,'Import Information'!$G:$G,"<>0")

This assumes the gross value information is held in column G, adapt as required.