worksheet function

  • Thread starter Thread starter kelly
  • Start date Start date
K

kelly

If B:B contains other numbers such as 404 and 405 could I
have c:c sum if B:B= 402 and 403 while A:A =312?
 
Hi
try
=SUMPRODUCT((A1:A100=312)*((B1:B100=402)+(B1:B100=403)),(C1:C100))
 
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

worksheet function 5
DSUM - SUMIF - or something else? 3
Sum based on date 3
find text from 1 col in 2nd col & return value from 3rd col 3
Sumproduct 1
Sum if two conditions met 3
lookup value if multiple matches are met 2
IF and 12

Back
Top