Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using a formula on cells containing results of formula How?
Your help greatly appreciated (first posting to a forum)
Scenario One workbook; two worksheets. The second worksheet contains, across multiple columns, the results of formulas in multiple rows (corresponding to rows in worksheet one shifts). The formula (referenced) is =IF(AND(I$1=shifts!$J3,I$1<shifts!$L3),"1","0"). This places either the value 0 or the value1 in a referenced cells. The column headings are from 06:00 hrs to 24:00 in 15 minute increments. The sheet contains columns to the left with codes (either F; 1; 2 and so on). At the bottom of each list of 15 minute columns containing the formulas (which shown the results either 0 or 1) I want to add up using =SUMIF(Mon!A2:A10,"F",Mon!I2:I10), which refers in this case to code F, all the 1s where F is the code. This works satisfactorily in a test sheet where 0 and 1 are entered manually but not when these values are the results of the IF/AND formula. I have prepared a cut down Workbook with some actuals in it if required and also have typed illustration to put here if required (but thought might be too much - this being new to me and not wanting to upset). Been looking on many sites for solution over past days. 22:00 signing off until tomorrow after work. In anticipation and gratitude. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a formula on cells containing results of formula How?
Drop the double quotes from your formula "1" is text whereas 1 is a number Does this help? proverbs Wrote: The formula (referenced) is =IF(AND(I$1=shifts!$J3,I$1<shifts!$L3),"1","0"). This places either the value 0 or the value1 in a referenced cells. This works satisfactorily in a test sheet where 0 and 1 are entered manually but not when these values are the results of the IF/AND formula. -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=533978 |
#3
|
|||
|
|||
Oh thank you John, yes it does. One for the records!
Phill (alias proverbs) with apology to administrator for not yet understand the 'snip' Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
CSE formula results | Excel Discussion (Misc queries) | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
Cells displays formula, not results | Excel Worksheet Functions |