Using SUMIF with an OR or ELSE

**cableghost** · 11-09-2021, 10:49 PM

In the attached WB, I need to add a formula into DATA U2. This formula will sum differently conditioned upon E2.

For example, if E2= Long use the following formula...

Please Login or Register  to view this content.

ELSE use...

Please Login or Register  to view this content.

I've tried something like the below, but neither work...

Please Login or Register  to view this content.

nor

Please Login or Register  to view this content.

**Gregb11** · 11-09-2021, 11:56 PM

Well, based on exactly what you said, then you should be able to use this in U2:

=IF(E2="Long",((O2*P2)+(Q2*R2))-((F2*G2)+(H2*I2)+(J2*K2)),((O2*P2)+(Q2*R2))-((F2*G2)+(H2*I2)+(J2*K2)))

**Fluff13** · 11-10-2021, 09:35 AM

Not sure if I'm missing something, but your 1st two formula look to be the same, based on your 3rd formula, maybe

Formula:

Please Login or Register  to view this content.

**cableghost** · 11-10-2021, 09:56 AM

Thank you both. Yeah, I had the wrong ELSE formula; since changed it. It's simply a reversal of the first.

The formula posted works, thank you. That's similar to what I had tried.

**Fluff13** · 11-10-2021, 09:58 AM

Glad to help & thanks for the feedback.

Using SUMIF with an OR or ELSE

LinkBack

Thread Tools

Rate This Thread

Display

Using SUMIF with an OR or ELSE

Re: Using SUMIF with an OR or ELSE

Re: Using SUMIF with an OR or ELSE

Re: Using SUMIF with an OR or ELSE

Re: Using SUMIF with an OR or ELSE

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Sumif - Trying to figure out how to tell a sumif to look for multiple naming conventions

[SOLVED] SUMIF: don't understand that purpose of the OFFSET inside SUMIF

Trying to sumif across sheets. SUMPRODUCT(SUMIF(INDIRECT function returns #REF error!

SumIf formula or Sumif with pivottable combined question

A reverse SUMIF (Or: Finding value whose sumif = a certain number)

Subtracting from the SUMIF with the difference from the SUMIF range

[SOLVED] Shorten SUMIF + SUMIF + SUMIF each with same reference range but different criteria???

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions