General discussion


Excel Formula Question

By Excel User ·
I'm using a formula in an Excel spreadsheet on Sheet1. I want to use the same formula on Sheet2. I think the formula needs the reference "Sheet1!" but when I try to add it, I get an error. I'm obviously not entering it at the correct place in the formula. The formula on sheet1 is =SUMIF(C13:C2238,"Health/Medical",G13:G223.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Repost as a Question.

by CharlieSpencer In reply to Excel Formula Question

Try reposting this using the 'Ask a Question' button. The 'Discussion' forum is for matters of general discussion, not specific problems in search of a solution.

There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the two forums, you'll find more of those members in 'Questions' than here in 'Discussions'.

Additional benefits to the membership include:

1) The "Questions" forum provides for your feedback, by way of your being able to mark "helpful" responses as such. This does not necessarily mean that a given response contained the complete solution to your problem, but only that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours, so that they might have a ready source of reference available, thereby perhaps obviating the need for them to repeat questions previously asked and answered.

2) The TR search function makes it difficult to find a particular "Discussion" or "Question" if it has not had a recent post; the two types get mingled in the listings. By keeping each type in their respective forums, it is easier for all to find what they are looking for..

Related Discussions

Related Forums