tammymaxson
New Member
- Joined
- Sep 8, 2006
- Messages
- 4
I wnat to create a summary sheet that looks at the master sheet and sums the data in column E only if it meets two or three other sets of cirteria:
For example: What formula would I enter to bring me the result of $200.00
I want a sum of the related data in column H if:
column d= "Problem"
and
Column I = "270"
and
Column H = "Pending"
Column D Column E Column H Column I
Problem 100.00 pending 270
Problem 100.00 not In Pending 270
Ready 100.00 pending 270
Problem 100.00 pending 180
Ready 100.00 not In Pending 270
Problem 100.00 pending 270
Currently I create a pivot table for this data print it out and the reenter the data manully into a differnt spreadsheet format. I tried just linking my fileds to the pivot table, but the minute on of the categories is not there in the pivot table the next month (like Ready) than the formula does not work, so I thought I could eliminate the pivot table step and use a sumif right in this field instead.
For example: What formula would I enter to bring me the result of $200.00
I want a sum of the related data in column H if:
column d= "Problem"
and
Column I = "270"
and
Column H = "Pending"
Column D Column E Column H Column I
Problem 100.00 pending 270
Problem 100.00 not In Pending 270
Ready 100.00 pending 270
Problem 100.00 pending 180
Ready 100.00 not In Pending 270
Problem 100.00 pending 270
Currently I create a pivot table for this data print it out and the reenter the data manully into a differnt spreadsheet format. I tried just linking my fileds to the pivot table, but the minute on of the categories is not there in the pivot table the next month (like Ready) than the formula does not work, so I thought I could eliminate the pivot table step and use a sumif right in this field instead.