![]() |
#1
|
|||
|
|||
![]()
Hi
I am struggling with a SUMIF formula and need some help. I am trying to build a Resource Capacity/Availability workbook and what I need to do in the SUMIF formula is as follows: Total the values in Sheet1 Column I where the Value in Sheet1 Column A is equal to the value in "Skillset Availability" Column A is equal to the value in Sheet1 Column A and the month value in "Skillset Availability" Cell C1 is the same as the month value of each date in Sheet1 Column E. Hope this makes sense. A sample workbook is attached to show where I have currently arrived at. Any help would be appreciated. Tony |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sumifs | lynchbro | Excel | 1 | 07-02-2014 09:27 AM |
![]() |
LeFoah | Excel | 2 | 10-20-2013 09:22 AM |
![]() |
sweetcuda | Excel | 13 | 08-26-2013 11:09 AM |
![]() |
docwhit | Excel | 2 | 01-05-2013 12:58 PM |
![]() |
Kheinrich119 | Excel | 2 | 12-12-2012 10:00 AM |