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 value’1’ 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 ‘1’s’ 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.

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 value’1’ 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

Oh thank you John, yes it does. One for the records!

Phill (alias proverbs)
with apology to administrator for not yet understand the 'snip'