| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Problem
Hello,
I have a workbook with two sheets, one detailed, one summary. I'm trying to sum the numbers entered in K2:Z11 everytime "16" is entered in A2:A11. This formula keeps returning 16. On the summary sheet 2, I entered the formula =IF(Sheet1!A2:A11,"16",SUM(Sheet1!K2:Z11)). Thank you in advance for any help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Problem
Have a look at the SUMIF function in Excel Help - you are nearly
there. Hope this helps. Pete On Apr 9, 4:11*pm, Cissy wrote: Hello, I have a workbook with two sheets, one detailed, one summary. *I'm trying to sum the numbers entered in K2:Z11 everytime "16" is entered in A2:A11. *This formula keeps returning 16. *On the summary sheet 2, I entered the formula =IF(Sheet1!A2:A11,"16",SUM(Sheet1!K2:Z11)). Thank you in advance for any help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Problem
I tried the SUMIF function, but get 1 as the answer, even though several
numbers are entered in the range. "Pete_UK" wrote: Have a look at the SUMIF function in Excel Help - you are nearly there. Hope this helps. Pete On Apr 9, 4:11 pm, Cissy wrote: Hello, I have a workbook with two sheets, one detailed, one summary. I'm trying to sum the numbers entered in K2:Z11 everytime "16" is entered in A2:A11. This formula keeps returning 16. On the summary sheet 2, I entered the formula =IF(Sheet1!A2:A11,"16",SUM(Sheet1!K2:Z11)). Thank you in advance for any help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Problem
Post the formula you are using, relating it to cells on your sheet.
Pete On Apr 9, 5:25*pm, Cissy wrote: I tried the SUMIF function, but get 1 as the answer, even though several numbers are entered in the range. * "Pete_UK" wrote: Have a look at the SUMIF function in Excel Help - you are nearly there. Hope this helps. Pete On Apr 9, 4:11 pm, Cissy wrote: Hello, I have a workbook with two sheets, one detailed, one summary. *I'm trying to sum the numbers entered in K2:Z11 everytime "16" is entered in A2:A11. *This formula keeps returning 16. *On the summary sheet 2, I entered the formula =IF(Sheet1!A2:A11,"16",SUM(Sheet1!K2:Z11)). Thank you in advance for any help.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem | Excel Discussion (Misc queries) | |||
| Formula problem | Excel Worksheet Functions | |||
| Formula Problem | Excel Worksheet Functions | |||
| problem with a formula | Excel Discussion (Misc queries) | |||
| Formula problem | Excel Worksheet Functions | |||
![Cissy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
