SUMIF functions

  • Thread starter Thread starter oldfield
  • Start date Start date
O

oldfield

Can anyone help with my problem what i want to do is add up the tota
for a given criteria in a column when it meets conditions of two o
more other columns
 
Various examples of two criteria

Counts number of records that equal both criteria
=SUMPRODUCT((RngA="abc")*(RngB="def"))

Counts number of records that equal both criteria
=SUMPRODUCT((RngA="abc")*(RngB>0))

Counts number of records that equal both criteria
=SUMPRODUCT((RngA=10)*(RngB=20))

Sums data from RngC where records equal both criteria in RngA and RngB
=SUMPRODUCT((RngA="abc")*(RngB="def")*(RngC))
 
Back
Top