cloughie

New Member
Joined
Feb 6, 2018
Messages
11
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?
 

Some videos you may like

Excel Facts

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

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,612
Messages
5,523,896
Members
409,542
Latest member
Shezz01

This Week's Hot Topics

Top