erutherford

Active Member
Joined
Dec 19, 2016
Messages
449
hate last minute change requests, but

The code works fine on the worksheet where the data resides, see below

<code>=SUMPRODUCT((I3:I51="S")*(J3:M51=2))</code>


but won't work when code is on another worksheet

<code>=SUMPRODUCT((Entries!I3:I51="S")*(Entries!J3:M51=2))</code>

what am I missing? Maybe I should take a deep breath!
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
It works fine for me.
- How is it not working? Are you getting an error or unexpected results?
- Are you sure that you have spelled the sheet name correctly? Anything different, even an "extra" space, will cause it to fail.
- Are your sure that this other sheet is in the same workbook?
 
Last edited:
Upvote 0
Ok I just try it on the worksheet where it should be, using another cell and it works

I just cut it from the test cell and pasted it into the correct cell and its functioning. I did delete a Conditional format that was there, maybe the cause?

Thanks as always for a quick reply!
 
Upvote 0
Conditional Formatting shouldn't have any affect on it.

You didn't say what the issue was, whether you were getting errors or unexpected results.
 
Upvote 0
The formula would just display in the cell and not function
That just means that you entered the formula as text, and not as a formula.
That will happen if the column is formatted as text to begin with.
Select the whole column, go to Format Cells, and change the format to General (that is typically the default).
Then when you enter formulas, then will enter as formulas and not text.
 
Upvote 0
You are welcome.
Once I knew what you were seeing, it became evident right away what the problem was.
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top