Additional To Be True Before Adding Total

[IanGreeff]

Good Day

I have been given a task to create a register for another department within our company. My original register was setup with the help of all the wonderful people on Mr Excel.

The new register I have to create is pretty much the same, however the formula I used before checked for 2 instances and then added the value of a certain column if those two instances were correct. Because I am using excel 2003 the formula is a bit long but is has been working without fail ever since used.

This is the formula

=SUMPRODUCT(--(ISNUMBER(SEARCH("Division",Leads!A14:A65536))),--(TEXT(Leads!B14:B65536,"mmm")="Jan"),Leads!K14:K65536)

The challenge I am facing now, is I need to have the Division, Business Type and Month to be checked before adding a the values.

I have no idea how to add another variable to this formula.

Could you guys kindly assist me.

Regards

 

[IanGreeff]

Sorry guys

I have managed to sort it out thanks.

Regards

 

[Andrew Poulsom]

If Business Type is in column C and the value to check is in A1:

=SUMPRODUCT(--(ISNUMBER(SEARCH("Division",Leads!A14:A65536))),--(Leads!C14:C65536=A1),--(TEXT(Leads!B14:B65536,"mmm")="Jan"),Leads!K14:K65536)