Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi, I am trying to create a formula that adds certain values from Column B
only if Column A equals a certain criteria AND Column C equals a certain criteria. Column A Column B Column C 23 23.88 V 23 100.00 M 24 9.95 M 24 23.88 M 25 23.88 V 25 23.88 V 26 23.88 A 26 23.88 A 26 23.88 M 26 23.88 M 26 23.88 V 26 9.95 V 27 23.88 A Specifically, I need the total from Column B for all M's on the 23rd, all V's on the 23rd, etc. In Column D, I've tried many different formulas but they either total the entire B Column (not just the cells that match the criteria) or they only "sum" Column B for the row the formula resides on. Any suggestions would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need help creating a formula for a specific result | Excel Discussion (Misc queries) | |||
What function will check a row for a series of specific numbers? | Excel Discussion (Misc queries) | |||
How do I create a formula to add values from specific fields? | Excel Worksheet Functions | |||
How do I create a formula to add values from specific fields? | Excel Worksheet Functions |