looks like you will use a sumifs formula
can you help me please?
without a sample worksheet, can i assume correctly that the top picture is sheet 1
and the bottom picture is sheet 2?
yes you are right
=SUMIFS(Sheet1!F:F,Sheet1!C:C,$A32,Sheet1!D:D,B$31)
This should work, test it on your worksheet on sheet2 cell B32
Perfect, Its Working, if I want to add same data from Diferent sheets in this formula, mean January+February+March to December, in all sheet same data I want to put all data in this sheet.
you can add an entire years worth of data to sheet 1 as long as the columns contain the same information as you stated above. the sumif formula i gave does not take dates into consideration so if you have jan-dec data it will look for the sum of the specific carrier and business for the entire year. if you want it to be broken out to sum specific dates as well you will need to add a cell somewhere to indicate what month you want to sum and add another criteria to the formula i gave you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks