IF statement

  • Thread starter Thread starter Kent Horsley
  • Start date Start date
K

Kent Horsley

I am currently working on a sales forecasting model with a IF statement that
says
=IF(jan!$m7="january".jan!$n7,0) which works very well as long as I am
looking only at Jan folder. My question is can you do a if statement that can
look from a jan folder through a Dec folder.
 
Why do you need to check for January? Doesn't the jan sheet have only
January data? If so, the If is unnecessary.

Regards,
Fred.
 

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

Average 2
Conditional/variable sum?? 7
USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY) 6
Using multiple IF statements 1
Specify columns to add for months MTD Diff 3
how do I average only certain cells based on month? 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
IF Statments in Excel 5

Back
Top