is there a formula for quarterly expenses in Excel?

M

Mike H

You don't give us too much to go on. This sums column B if the corresponding
date in column A is in Q1

Change =1 to =2 for Q2 wtc

=SUM(IF((INT((MONTH(A1:A100)-1)/3)+1)=1,IF(A1:A100<>"",B1:B100,0)))

This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for returning quarter based on current date? 4
Quarter function based on current date 1
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Filtering data from a non-continuous list 3
Multiple If statements, Calculating quarterly % holding costs 0
QUARTERLY Profit and Loss Statement 1
I need a mathematical thinker. 6
Calendar Logic: Recurring Dates 3

Top