Thread: Formula Help??
View Single Post
  #1   Report Post  
Urgent
 
Posts: n/a
Default Formula Help??

I'm creating a huge spreadsheet. This is an example of one of the formulas
that I'm using
(=SUMPRODUCT(--(March!$C$3:$C$18="2E"),--(March!$F$3:$F$18="head")). Now
since I have a spreadsheet created for each month it is very time consuming
to go in and change 30+ formulas so that it is calculating for April, then
May, June. Is there a function that I can type in so that the formula will
automatically pick up the name of the spreadsheet???

Thank you for you help.