| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif want to sum a range bigger than one column
act 1 2
act 3 4 hr 5 6 act 7 8 I want to sum all the numbers in both columns B and C if the office code is "hr" in otherwords, sumif(a1:a4,"hr",b1:c4) to produce 11 (or 5 + 6). Excel returns just the first column, or 5. Do not want to break into two "sumif" statements...too much data. Array?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 (9.0.6926 SP3) spreadsheet getting bigger & bigger .... | Excel Discussion (Misc queries) | |||
| How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
| Sumif where sum range is more than one column? | Excel Worksheet Functions | |||
| SUMIF using a multiple-column range | Excel Worksheet Functions | |||
| SUMIF using a multiple-column range | Excel Worksheet Functions | |||
Threaded Mode
