Gold Price,Silver Price

SUMPRODUCT if Fields Match a RANGE of Criteria [SOLVED] - Excel Help Forum
I'd like to be able to use SUMPRODUCT to sum up a range of cells for which its category corresponds to a list of my criteria For example (see attached), I want to sum up all cells in column B with a Category of A, B, or C (which is listed out in a range in column A), resulting in an output
=SUMPRODUCT(the bees knees) [for dummies] - Reddit
The filter argument must be parallel to the range arguments if you won't be multiplying arguments Otherwise, this is the formula you can use for the table you have: =SUMPRODUCT((E7:F8)*(E6:F6="B"))
How to sumproduct (sumifs ()) with multiple LIST criteria
Post few sample data and show your desired output KeyDate[#Data] and KeyNames[#Data] need to be orthogonal, i e one a vertical range, the other horizontal
How to correct a #VALUE! error in the SUMPRODUCT function
If one or more cells in the referenced range contains text or is formatted as a Text data type, you will get the #VALUE! error The text could be the result of a calculation from another formula, or maybe the cell is simply not formatted correctly
excel - Using a list (range) of row and column critiera (not single . . .
Idea is to use COUNTIF as FILTER criteria for multiple values: Just keep in mind that you need to look for headers IN criteria range and not vice versa: Using just COUNTIF and multiplication: =SUM(IF(COUNTIF(H2:H3,B1:F1)*COUNTIF(I2:I3,A2:A12),B2:F12)) might just do Nice solution!