building a formula
Hi all
I have been aske to make a spreadsheet that will build a set of formulas
based on the number of sheets being used. The sheets are name shA, shB etc
and can change. The formaula that I need is on a summary sheet and is as
follows:
fname = "=SUMIF(" & tmpName & "!E8:E107," & "=LO" & ",HT_end!D8:D107)"
where tmpName is the name of each spreadsheet, LO is the criteria for the
search.
The result is :
=SUMIF(HT_end!'E8':'E107',LO,HT_end!'D8':'D107') I was after
=SUMIF(HT_end!E8:E107,"LO",HT_end!D8:D107)
Any ideas or better method appreciated
Thanks
|