|
|
|
|
#1
01-22-2015, 07:26 AM
|
|||
|
|||
First off, remove the space from the first tab. It will make you equations more aesthetic. Doing so and making it so the equation is copyable results in:
=SUMIFS(AllData!$C:$C,AllData!$A:$A,$A6,AllData!$B :$B, ">=" &C$5,AllData!$B:$B,"<" & D$5) I added some more date headers as the equations in Column E, for example, refer to the date header in Column F. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
| "No printers are installed" error when copying cells | Dark Pumpkin | Excel | 5 | 06-14-2014 03:59 AM |
 How to choose a "List" for certain "Heading" from "Modify" tool?
|
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
| "Favorites" disappear when copying Outlook.pst file | ADG | Outlook | 1 | 09-02-2010 05:53 AM |
|
Excel 07 formating 17 cells "Need Formula"
|
Raner | Excel | 2 | 05-30-2010 02:07 PM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode