FG

Using two conditions with a SUMIF function in Excel 2003

Fresh3 days ago
Mar 15, 202614627 views
Confidence Score0%
0%

Problem

For a given row on Sheet1, I use the function to see if the value from the first cell of that row is on a list of historical values in Sheet2. That will basically summarize all the values on my historical sheet and group them by my A1 cell name on Sheet2. I need a second condition so that I can gro…

Error Output

SUMIF

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Using two conditions with a SUMIF function in Excel 2003

Low Risk

Assumptions: Dates are in column B Rows are 5:29 historical list in a range name 'Historical' Month to test is in a range name 'rngMonth'

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment