SUM+IF STATEMENTS

[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

 

[T. Valko]

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)

 

[Fred Smith]

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]...