Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif or Sumproduct? Maybe neither?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif or Sumproduct? Maybe neither?
Hi!
Sumproduct: =SUMPRODUCT(--(B1:B100="NoDup"),--(M1:M100="Y")) Better: A1 = NoDup A2 = Y =SUMPRODUCT(--(B1:B100=A1),--(M1:M100=A2)) Biff "Steve" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif, sumif, sumproduct - I dont know which to use | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SUMPRODUCT or SUMIF | Excel Worksheet Functions | |||
SUMPRODUCT or SUMIF or ... | Excel Worksheet Functions | |||
Sumif not Sumproduct | Excel Worksheet Functions |