summing a column according to criteria of two other columns

  • Thread starter Thread starter Samantha
  • Start date Start date
S

Samantha

I am creating a cash flow forecast sheet and trying to add up the
project values of a particular service provided in june this year. i am
attempting to do this by referring to a sheet called data which has a
column of project values (N), a column with the month and year of the
project (V) written as 62004 and a column of services (E) of which i
want to select those projects where the service was Translation -
Standard. By looking at the help for countif by multiple criteria i
altered the formula to a sumif. I am using the formula...
=SUM(IF((Data!$E$3:$E$2000='Translation -
Standard')*(Data!$V$3:$V$2000=62004) ,Data!$N$3:$N$2000)). This doesnt
come up as an error however i know that there are projects under this
criteria yet the cell is coming up as zero. Any help with this problem
would be extremely appreciated, cheers, sam.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 
Hi
do you mean:
=SUM(IF((Data!$E$3:$E$2000="Translation -
Standard")*(Data!$V$3:$V$2000=62004) ,Data!$N$3:$N$2000))

this formula has to be array-entered (with
CTRL+SHIFT+ENTER)
 
Back
Top