| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dividng numbers using the sumif function
I need help in setting up a simple formula. I have 2 worksheet tabs -my
formula is =Sumif(B3:B12)/Products(B4:b16) - in others I want to add numbers in cells B3:B12 (tab 1) and divide the total by numbers in 2nd worksheet tab B4:B16 using the sumif function since all cells already have formulas in them. This is probably simple, but I don't grasp formulas very well, too new. thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
| Sumif only numbers formated as currency | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
| Sumif for lowerst value within limited to 2 numbers only | Excel Worksheet Functions | |||
Threaded Mode
