• ## Other - General

### Forum Guide

by Published on 2016-11-06 11:48 PM

Getting the Most From Excelguru Forums
We take a lot of pride in providing good help, and really want our users to walk away with an answer to every question.

How the Forum Works

Using the Forum
Before you can post a question, you must register and log into the forum. This is generally a 3-step process:

1. Register
2. Activate

If you haven’t already done so, you need to register for an account by visiting our forum registration page. Fill out the form and click on the white “Complete Registration” button.

Once you’ve submitted your registration, you will receive a confirmation email from (webmaster)@excelguru.ca. Inside that email is an activation link. Please click it to confirm ...
• ### Recent Forum Posts

#### How to return and sum columns based on criteria/s

[QUOTE=NBVC;37076]Assuming the aquisition date is 1st of the month, try:

[COLOR=#0000ff]=SUMIFS(STRAIGHTLINE!\$D\$6:\$D\$8,STRAIGHTLINE!\$I\$6:\$I\$8,">0",STRAIGHTLINE!\$E\$6:\$E\$8,"0",STRAIGHTLINE!\$E\$6:\$E\$8,"0",STRAIGHTLINE!\$B\$7:\$B\$401,"Totals")-SUMIFS(STRAIGHTLINE!\$I\$7:\$I\$401,STRAIGHTLINE!\$B\$7:\$B\$401,"Totals")+SUMPRODUCT((STRAIGHTLINE!\$K\$7:\$K\$401:INDEX(STRAIGHTLINE!\$K\$7:\$V\$401,,MATCH(SUMMARY!\$E\$2,STRAIGHTLINE!\$K\$4:\$V\$4,0)))*(STRAIGHTLINE!\$B\$7:\$B\$401"Totals"))+STRAIGHTLINE!Z6...

nmmnyr Today, 12:37 AM

#### Categorizing based on multiple conditions & criteria containing text

Yes, I realized it was just a combination of the two different type of statements above as you also stated here. Thanks again, this was a huge help!...

AnnaB Yesterday, 10:25 PM

#### Need help with the diagram

I need this data in a diagram

something like this

Its very important that the percent value is the visual diagram and the 3rd...

J0hNTH3P4P7T0 Yesterday, 08:14 PM

#### Categorizing based on multiple conditions & criteria containing text

Do you mean?

=IF(A2="","",IF(OR(ISNUMBER(SEARCH({"X","Y"},A2))),"Category1",IF(OR(ISNUMBER(SEARCH({"A","B","C"},A2))),"Category2",IF(OR(ISNUMBER(SEARCH({"M","N"},A2))),"Category3","Other"))))...

NBVC Yesterday, 06:38 PM

#### Categorizing based on multiple conditions & criteria containing text

Actually, I do have one more follow up questions. How would you recommend I go about blanks vs. "other". I see you have an else ""...

AnnaB Yesterday, 05:33 PM