• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Can anyone help me with writing this Excel formula?

J

joshw10

Senior member
Im trying to write a formula and having some trouble figuring it out

In Column A, I have dates. In Column B, I have numbers. I want a formula that generates the sum of Column B, so long as the corresponding dates in Column A are within a specified range (such as only January 2006)

If anyone could help with this it would be appreciated!
 
should be in software forum, but here:

=SUMPRODUCT((A1:A10>=DATEVALUE("1/1/2006"))*(A1:A10<=DATEVALUE("1/31/2006"))*(B1:B10))

(where your dates are in A1 to A10. numbers are in B1 to B10) it's an array formula, so paste that in B11 and hit Control Shift Enter (all at the same time) in the formula bar

braces {} will show up around it to show it is an array formula
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top