Convert SUMIFS formula from 2007 to 2003

B

Bob Umlas

=SUMPRODUCT(N(Sheet1!A2:A11=Sheet2!$A2),N(NOT(ISERROR(FIND(Sheet2!B1,Sheet1!C2:C11)))),Sheet1!D2:D11)
 
F

Fellipe C. Moreira

Thanks for the quick response Bob!

However I couldn't make it work, it's giving me 0 when it should give me
other value as the other does, any idea?
 
T

T. Valko

=SUMIFS(Sheet1!D2:D11,Sheet1!A2:A11,Sheet2!$A2,Sheet1!C2:C11,"*"&Sheet2!B$1&"*")

Try this:

=SUMPRODUCT(--(Sheet1!A2:A11=Sheet2!A2),--(ISNUMBER(SEARCH(Sheet2!B1,Sheet1!C2:C11))),Sheet1!D2:D11)
 
F

Fellipe C. Moreira

This one worked, thanks a lot!

T. Valko said:
Try this:

=SUMPRODUCT(--(Sheet1!A2:A11=Sheet2!A2),--(ISNUMBER(SEARCH(Sheet2!B1,Sheet1!C2:C11))),Sheet1!D2:D11)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multisheet range in SUMPRODUCT? 5
SUMIF(S) not available on Excel 2003 18
Convert SUMIFS formula from 2007 to 2003 5
Macro to copy cells from one worksheet to another 1
Autofiller Tool Help 3
Fill & Drag to Right !! HELP ! 2
Variable Range in Formula 2
Excel formula request 0

Top