SUMIF(OR(???

I am trying to sum a column if either my Paid in 1st half in 2019 column is checked or my Paid in 2nd half in 2019 column is checked. I am trying to use a few different formulas without success.

Here are a two that I've tried:

=SUMIF(OR([Paid 1st half in 2019]:[Paid 1st half in 2019], [Paid 2nd half in 2019]:[Paid 2nd half in 2019], "1")[Estimated Pay #1]:[Estimated Pay #1])

=SUMIFS([Paid 1st half in 2019]:[Paid 1st half in 2019], "1" , [Paid 2nd half in 2019]:[Paid 2nd half in 2019], "1")[Estimated Pay #1]:[Estimated Pay #1]

This formula worked for just one of the criteria

=SUMIF([Paid 1st half in 2019]:[Paid 1st half in 2019], "1", [Estimated Pay #1]:[Estimated Pay #1])

Find more posts tagged with

Formulas

Real Estate

Marketing

Comments

L_123

=SUMIF([Paid 1st half in 2019]:[Paid 1st half in 2019], 1, [Estimated Pay #1]:[Estimated Pay #1])+SUMIF([Paid 2nd half in 2019]:[Paid 2nd half in 2019], 1, [Estimated Pay #1]:[Estimated Pay #1]) -SUMIFS([Estimated Pay #1]:[Estimated Pay #1],[Paid 1st half in 2019]:[Paid 1st half in 2019], 1 , [Paid 2nd half in 2019]:[Paid 2nd half in 2019], 1)

Something like that might work. I've spread it out a bit down below.

Sum if paid in first half

=SUMIF([Paid 1st half in 2019]:[Paid 1st half in 2019], 1, [Estimated Pay #1]:[Estimated Pay #1])+

Plus sum if paid in second half

SUMIF([Paid 2nd half in 2019]:[Paid 2nd half in 2019], 1, [Estimated Pay #1]:[Estimated Pay #1]) -

Minus paid in both halves

SUMIFS([Estimated Pay #1]:[Estimated Pay #1],[Paid 1st half in 2019]:[Paid 1st half in 2019], 1 , [Paid 2nd half in 2019]:[Paid 2nd half in 2019], 1)

KaitlinH2

Thank you!

I ended up using just the first part below and it worked!!! I don't know why I was trying to get all crazy when I could've done a simple formula lol.

=SUMIF([Paid 1st half in 2019]:[Paid 1st half in 2019], 1, [Estimated Pay #1]:[Estimated Pay #1]) + SUMIF([Paid 2nd half in 2019]:[Paid 2nd half in 2019], 1, [Estimated Pay #2]:[Estimated Pay #2])

Sign in to join the conversation!

Quick Links

Trending discussions

A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
Missing column in Report if I use a formula
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?
SUMIF function not working
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…