Sumif or Sumproduct? Maybe neither?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Column B has a formula result of either "DUP", "NoDup" or it is blankk "".
Column M has text entries of either "Y" or "N". I would like to get a count
of how many times "NoDup" and "Y" appear in the same row.

Any help is always appreciated.

Steve
 
Hi!

Sumproduct:

=SUMPRODUCT(--(B1:B100="NoDup"),--(M1:M100="Y"))

Better:

A1 = NoDup
A2 = Y

=SUMPRODUCT(--(B1:B100=A1),--(M1:M100=A2))

Biff
 

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

Sumif or Sumproduct 1
Scrabble Value calculation for Welsh words 0
Sumproduct Count, Allow Or Two Fields 2
sumif & sumproduct 7
Sumproduct query 4
Sumproduct neither nor 4
sumifs/sumproduct 8
SUMIF with criteria "<>" & "=" 4

Back
Top