Convert SUMIFS formula from 2007 to 2003

  • Thread starter Thread starter Alex.W
  • Start date Start date
=SUMPRODUCT(N(Sheet1!A2:A11=Sheet2!$A2),N(NOT(ISERROR(FIND(Sheet2!B1,Sheet1!C2:C11)))),Sheet1!D2:D11)
 
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?
 
=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)
 
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...
 
You must log in or register to reply here.

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
Finding Data 2
Autofiller Tool Help 3
Sorting and COUNTIF 6
COUNTIF, Sorting, on Two Sheets 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Macro to copy cells from one worksheet to another 1
Serach for multiple words in one cell 3

Back
Top