Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula copy for December
I got 12 worksheets updated daily (writting names of U.S. States), named as
the months. I got another worksheet that feeds from those 12 worksheets(JAN,FEB,MARCH...) Something like this ( I just used Nov. for obvious space reasons) A B C D jan feb nov dec 1 NY 501 2 GA 333 3 FL 612 This is my formula: COUNTIF(NOVEMBER!F2:F300"NY") in C1 COUNTIF(NOVEMBER!F2:F300"GA") in C2 -- COUNTIF(NOVEMBER!F2:F300"FL") in C3 Q: Can I copy from C to D and change NOVEMBER to DECEMBER each time without doing it manually ( meaning writing DECEMBER one by one in D )? Thanks for the answer or at least for the feedback. Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
Copy Formula Down Without Changing Entire Formula | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Copy formula so destination displays formula as text | Excel Discussion (Misc queries) |