Combining AND,SUMPRODUCT & IF

[reggie1000]

Hello,

i have a problem combining Sumproduct and two or more IF functions, i have tried to combine the two but i am coming up with errors, here it is,

i have vendors that work throughout the week, if the vendor works on a particular day, revenue is entered against him, a very simple sumproduct formula, but i need to indentify if the vendor either doesn't work on a particular or if no revenue is entered against that day.

i have tried using an array, but i'm not that familar with what they can or can't do.

i have attached a sample file with expected results, if someone could have a look.

many thanks reg

[NBVC]

Try this in G4:

Please Login or Register  to view this content.

[reggie1000]

Thanks again NBVC

works great

cheers reg