FG
💻 Software

Excel formula for "select sum(B) where month(A)=3"

Fresh5 days ago
Mar 15, 202624689 views
Confidence Score0%
0%

Problem

I have excel data as follows: I want show the Total Cost for each month. I can achieve this in Google Spreadsheets with the following formula: Which gets the result for April. But my requirement is now to do the same in Excel (which doesn't support the QUERY statements). I have been playing around …

Error Output

=INDEX(QUERY(COSTS!$1:$1101,"select sum(B) where month(A)=3"), 2)

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel formula for "select sum(B) where month(A)=3"

Low Risk

As column A is a date you will need something like this to test that the month is March(3), April(4) etc to match it, below is one way ie for March for April

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment