# if and sumifs

#### cloughie

##### New Member
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?

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### Gerald Higgins

##### Well-known Member
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.

Replies
8
Views
122
Replies
3
Views
102
Replies
2
Views
35
Replies
14
Views
174
Replies
11
Views
132