SUMIF using multiple Criteria

  • Thread starter Thread starter Dave Matthews
  • Start date Start date
D

Dave Matthews

I am trying to get results for a SUMIF Question
I have two worksheets that I am using and both are in the same
workbook. the first sheet has three columns, one has different
named Construction items (Clm F), one has numbers 1 thru 10 (Draws -
Clm G)and the last one has pricing for the construction items (Clm H).
The construction items sometimes appear more than once using the same
draw # and always appear listed again with a different draw number. On
the second sheet I want to see
the sum for the various construction items for draw 1, 2 and so on
a couple of formulas I have tried are:
=IF(Invoices!G$3:G$203=1,SUMIF(Invoices!
F$3:F$203,B16,Invoices!F$3:F$203),"") with the intent of copying down
20 cells (B16:B36 being the construction items to sum )
another formula I have tried is =
SUM((G3:G203=B16)*(G3:G203<>1)*(H3:H203) Both have been entered as
array
formulas. The problem is that it will sum the totals on the second
sheet until the draw number changes on the first sheet.
I am trying to have separate Columns for each draw on page two
with the totals to date for each construction item.
If anyone has any ideas or suggestions it would be very much
appreciated
Thanks



------------------------------------------------




------------------------------------------------
 
It is not clear from your post
- what you are trying to do (your two formulas do not appear to be
trying to do the same thing)
- what is going wrong

The second formula (array entered) is a standard way to sum by multiple
conditions, but I have never known it not to update.

Jerry
 
Back
Top