SUMIF with criteria "" & "="

I'm using excel 2007. I have 2 columns of data. A1:A8 contain various numbers only. B1:B8 contain numbers, text, & empty cells. I use the formula SUMIF(B1:B8,"<>",A1:A8). This works fine for my needs as I'm trying to sum the ...

Message posted on the May 7th, 2013 - 5:38 AM ET

SumIf equation question

Hi, I'm using the below SumIf equation, however the range in Column G is formula and so the sum always comes out to 0. Is there a way to get the below forumla to only sum the values in H i the formula in G shows a value, and ignore anything cells ...

Message posted on the May 3rd, 2012 - 4:40 AM ET

sumif?

I need to sum the Ax fields if the name in column D is the same as the name in D1 and place the total in a1. I think it is SUMIF but how? 0 RD V/W - Type Effect - abs % # Fonds 17.98 0.44% 3.05 2.96% 1 AGN ...

Message posted on the April 25th, 2013 - 2:01 PM ET

Sumif & Countif

Hi, I'm trying to use the countif & sumif to find which item driving th 80% sales. Do you have any better formula to calculate the 80% accurately. I'v attached my working here. column D =COUNTIF(C2:C10,">10.5%") column E ...

Message posted on the July 7th, 2012 - 7:11 AM ET

SUMIF over multiple spreadsheets

Hi, I would like to use the following formula over 30+ worksheets in th same workbook but I do not want to have to repeat sum if over and ove again. I have tried my own research and most people suggest sumif wit sumproduct and indirect but I ...

Message posted on the June 30th, 2012 - 6:17 PM ET

quick question on sumif

Hi, I have a file which use the sumif function pulling the data from another file. The issue is that if the file where the sumif is pulling from is closed and I say filter the other file, i get the #VALUE error. I was told that the sumif function ...

Message posted on the May 25th, 2011 - 9:52 AM ET

SUMIF Formula with automatic updating dates in forumla.

I have a spreadsheet (workbook 2) where I am getting date from anothe spreadsheet (workbook 1) and it gets data according to different tab with in workbook 1, at the moment I am have to manually change the dat each time according to the tab I need ...

Message posted on the February 7th, 2012 - 7:02 AM ET

Sumif similar to Countif??

Hello. I'm looking for a variation of the formula Countif tht will operate in a similar fashion to the Sumif. In column A I have various categories. In column B I have either blank cells or numbers. I need to scan column A to indentify a ...

Message posted on the March 14th, 2012 - 10:48 AM ET

sumif to add more than one column of cells.

dear all, I have a table below : Col Row A B C 1 X 1 2 2 Y 3 4 3 Z 5 6 Then, I have a formula in D1 below, but it only returns "1" as the result, which I expect to be "3" (1+2), please help. ...

Message posted on the February 3rd, 2013 - 10:12 PM ET

VLOOKUP or SUMIF for Multiple Criteria

Im hoping this is possible. I am looking for a formula that will sum a large range of data in a specified column corresponding to multiple criteria that does not repeat. Example below: Fee Type 12/31/2012 3/31/2013 6/30/2013 Fee Type ...

Message posted on the November 9th, 2012 - 11:00 AM ET

Help on the Sumif Function

I have a budget table where I input data every week. I want to create another table that shows how much I've spent every month. So for the Month of April my equation looks like SUMIF(Table[Date], MONTH(4), Table[Debit]). My value comes up as zero. ...

Message posted on the November 8th, 2012 - 11:04 AM ET

Crafting SUMIF formula

I'm a novice at Excel and am trying to craft a SUMIF formula. The formula will be in one cell only and I have named that cell "InstalledRevenue". I want to add to the value of "InstalledRevenue" the value of any cell in Column M ...

Message posted on the December 22nd, 2011 - 4:11 PM ET

sumif wildcard for text and numbers

Hi, I have a large spreadsheet that sums a column if there is an "x" in another column: =SUMIF($J102:$J302,"x",$AL102:$AL302) I need to change some of the "x"'s to numbers but I would stil like to sum in the same ...

Message posted on the August 24th, 2012 - 8:10 AM ET

sumif issues

Hi I am taking an online class with basic excel 2010 functions/formattin etc.. and I noticed this issue: the worksheet for the class has a list of employees and data - salary names, id, gender etc... on the second sheet you learn to use sumif fxn.. ...

Message posted on the August 19th, 2012 - 12:08 PM ET