Sumif

**5mac** · 10-17-2019, 03:47 PM

Hi All, I need help with this one, I've looked everywhere to no avail - i'm sure someone out there can solve it....
what I need to do is;
if cell C1 equals 2 then multiply C1 by 7% (or cell b1), or if C1 equals 3 then multiply by 13% (or cell b2), or if C1 equals 4 multiply by 17% (or b3) and so on
I've been looking at sumif formulas, but cant seem to get anything to work.

Thanks

**modytrane** · 10-17-2019, 03:52 PM

why do you think you need sumif?
can you attach a sample file so we can see what you're trying to accomplish?

you can simply write IF statements

=if(C1=2, C1*B1, if(C1=3, C1*B2, if(C1=4, C1*B3, ""))).....

**protonLeah** · 10-17-2019, 08:08 PM

Please Login or Register  to view this content.

Sumif

LinkBack

Thread Tools

Rate This Thread

Display

Sumif

Re: Sumif

Re: Sumif

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???

Bookmarks

Bookmarks

Posting Permissions