Adding Worksheet To Formula

G

Guest

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.
 
R

rsenn

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding total via entered text 4
Help With Formula 6
Formula Count dates multiple criteria 3
SUM DATA RANGE 4
how to link multiple columns to multiple worksheet totals / functi 5
New Year 3
Formula changes on own accord 7
Finding Text To Copy To Another Worksheet 1

Top