Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Would someone please help me think this through....
I have a workbook with a sheet named Susan and a sheet named Totals. On the Susan sheet, column C is a yes or no answer (using data validation). Column E is for dollar amounts. OK...on the Totals worksheet, I need a line that says Yes Totals (which totals all the Yes's in column C of sheet Susan) and one under that that says No Totals (which totals all the No's in column C of sheet Susan) Example on the Susan sheet C6=Yes E6= $100 C7=Yes E7= $50 C8=No E8= $10 C9=Yes E9= $15 C10=No E10=100 On the totals sheet I want it to read: Yes $165 No $110 I'm sure I can do it with a SUMIF, but I'm getting myself totally confused at this point. TIA Dino |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |