Hi,
I set up a SUMIF forumula shown below;
Please note that the formula is set up in "Data Table 2":
"=SUMIF('Data Table 1'!E5:E100,A3,'Data Table 1'!G5:G100)",
where within column E - cell 5 to 100, the criteria in cell A3 (in Data Table 2) is searched for and then adds all the numberical values with in column G - cell 5 - 100 (in Data Table 1) that correspond to the criteria in cell A3.
This formula works well for what I needed, but I need somthing a little different for my next project.
I need to search for a criteria in a column A, once I have found all the cells (there may be more than one cell that meets the criteria) that meet the criteria, I need to find in column B all the cells that have the word "Incomplete" associated within the row that meets the criteria. So...is there a way I can combine SUMIF and VLOOKUP formulas to do this.
Thanks in advance for any help
Calli
Bookmarks