SUM+IF STATEMENTS

  • Thread starter Thread starter Patricia H
  • Start date Start date
P

Patricia H

I have two worksheets-one that contains data and the other formulas calculating form the data set worksheet. My problem is that the information is constantly changing on the data wrksht so the cell location changes and I have to change my formulas on the calculation page.

What formula should i use to handle this?? This is an example of what i need to calculate...

Sum of column G if column C=TEXT A, column E=TEXT B, and column F=TEXT C


Submitted via EggHeadCafe - Software Developer Portal of Choice
SharePoint Video Library Template Available For Download
http://www.eggheadcafe.com/tutorial...05-5995f2b0ab63/sharepoint-video-library.aspx
 
Use cells to hold your criteria...

A1 = TEXT A
B1 = TEXT B
C1 = TEXT C

Then:

=SUMPRODUCT(--(C1:C100=A1),--(E1:E100=B1),--(F1:F100=C1),G1:G100)
 
If you have 2007, you want Sumifs. If not, use Sumproduct, as in:
=SUMPRODUCT(--(C1:C100="TEXT A"),--(E1:E1000="TEXT B"),--(F1:F100="TEXT
C"),G1:G100)

Adjust the range to suit. You cannot use full columns.

Regards,
Fred

in message
news:[email protected]...
 
Back
Top