Hello
I am trying to use the SUMIF function with multiple criteria, show in the attached example is what I am trying to achieve.
So in column F I need only the actual values to be counted for each of the Departments in column A.
I need this to work for additional entries that will be added in future.
Any help will be appreciated thank you.
The merged cells are your problem. Get rid of those and then try the SUMIFS function.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Department BS x BS G2: =SUMIFS($D$2:$D$15, $A$2:$A$15, F2, $C$2:$C$15, "Actual") BS x ARCH ARCH xx ASB ARCH xx MECH ASB xxx ASB xxx MECH xxxx MECH xxxx BS xxxxx BS xxxxx BS xxxxxx BS xxxxxx ARCH xxxxxxx ARCH xxxxxxx
Entia non sunt multiplicanda sine necessitate
Thankyou that's works perfectly
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks