Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Worksheet To Formula
Below are two formulas that I have are on one worksheet. I need the
remaining formula added in order for them to calculate from another worksheet titled Overall. =COUNTIF(--(MONTH(O31:O980)=MONTH(C3))) =COUNTIF(--(MONTH(O31:O1001)=MONTH(C3)),--(ISNUMBER(SEARCH(A10,S31:S1001)))) Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Worksheet To Formula
Anybody???
Thanks. "roy.okinawa" wrote: Below are two formulas that I have are on one worksheet. I need the remaining formula added in order for them to calculate from another worksheet titled Overall. =COUNTIF(--(MONTH(O31:O980)=MONTH(C3))) =COUNTIF(--(MONTH(O31:O1001)=MONTH(C3)),--(ISNUMBER(SEARCH(A10,S31:S1001)))) Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Worksheet To Formula
Roy, Two things. One, the syntax of your COUNTIF formula seems to be wrong. It apparently should be COUNTIF(range,criteria). I get an error message when I try your formula. Two, I'm having a hard time divining what you mean by "remaining formula." Can you explain that. Sorry I couldn't help as is. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=487414 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Worksheet To Formula
I need the formula that will pull the info from the Overall worksheet. My
CountIf formulas work fine when they are on the Overall worksheet where all the info is. Now I want to calculate that info but have it pull over to another worksheet. "rsenn" wrote: Roy, Two things. One, the syntax of your COUNTIF formula seems to be wrong. It apparently should be COUNTIF(range,criteria). I get an error message when I try your formula. Two, I'm having a hard time divining what you mean by "remaining formula." Can you explain that. Sorry I couldn't help as is. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=487414 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a formula within a formula | Excel Worksheet Functions | |||
Sum formula is not adding up properly | Excel Discussion (Misc queries) | |||
Updating formula with link to another worksheet using vlookup | Links and Linking in Excel | |||
help keeping the worksheet names within formula | Excel Worksheet Functions | |||
Worksheet references another tab in formula | Excel Worksheet Functions |