Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-08-2019, 09:02 AM
arndts arndts is offline Sumproduct Windows 10 Sumproduct Office 2016
Novice
Sumproduct
 
Join Date: Jan 2019
Posts: 3
arndts is on a distinguished road
Default Sumproduct

In a spreadsheet (see attached imaged), I have a table that has 3 groups. Each group has 4 rows and 8 columns.



In column B, the cell in row 1 in each group contains the text "Hours". In column B, the cell in row 3 in each group contains the text "Cost". Note: the cells in column B, rows 1 and 2, are merged. Note: the cells in column B, rows 3 and 4, are merged for display purposes.

In column C, the cell in row 1 in each group contains the number of Hours. In column C, the cell in row 3 in each groups contains a currency cost value.

In column G, the cell in row 1 in each group contains the text "High", "Medium" or "Low". Note: In column G, the cells in row 1 through 4 are merged for display purposes.

In column H the cell in row 1 in each group contains the text "Full", "Mentored", "One-Time" Note: In column H, the cells in rows 1 through 4 are merged for display purpose.

Note: This is a subset of a larger table with a lot more groups with different combinations of these values.

Depending on the values in columns G and H, I want to sum the related hours and costs for each combination.

So far, I can calculate the Hours for each combination using a formula similar to the following

=SUMPRODUCT(($B$1:$B$12="Hours")*($G$1:$G$12="High ")*($H$1:$H$12="Full")*($C$1:$C$12))

But I can't figure how to construct the formula for Cost.

Thanks
Attached Images
File Type: png excel table.png (14.2 KB, 20 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with a SUMPRODUCT Formula OTPM Excel 12 05-17-2017 04:04 AM
Sumproduct Countifs and Sumproduct Algo Excel 6 11-13-2012 07:44 AM
sumproduct?? jer Excel 9 10-14-2012 10:00 AM
Sumproduct Sumproduct formula Portucale Excel 2 09-12-2012 10:51 AM
Sumproduct Sumproduct angie.chang Excel 3 06-14-2012 10:00 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft