| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on formula for autosum on 2 criteria in 2 ranges
I need to get a sum from 2 different criteria in 2 different ranges.
PLace Type $$ a 1 3.00 a 2 5.00 b 1 c 1 d 1 My end result would be for all "a" in Place column and all "1" in Type column then auto sum of Column $$ ((Range,critera) and (range critera) {sum_range}) but i can't make it work I'm missing something Help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting two ranges for one criteria | Excel Worksheet Functions | |||
| Sumif with 2 ranges & 2 criteria | Excel Worksheet Functions | |||
| multiple ranges & criteria for SUM-IF challenge | Excel Discussion (Misc queries) | |||
| named ranges in multiple criteria formula | Excel Discussion (Misc queries) | |||
| How to put ranges in Criteria.. | Excel Discussion (Misc queries) | |||
Threaded Mode
