Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spreadsheet where all entries in Col A are either "E" or "S". Col B
has 10 different possible entries. I need a formula to 1st, select every row that is an "E", then 2nd, out of that, select only the rows that match a criteria for Col B's possibilites and 3rd, using the rows that the 2nd step selected, add all of the values in Col C and generate a total. I have various modifications of IF and SUMIF and cannot get anything to work. Any help would be greatly appreciated. |