help: break this down

collinsc

Board Regular
Joined
Sep 13, 2006
Messages
230
Hi all

Can you please help me to break this down:

=1-(SUMIF('Project Resource Plan'!$A$3:$A$119,$B10,'Project Resource Plan'!G$3:G$223)+SUMIF(Completed!$A$2:$A$373,$B10,Completed!BA$2:BA$373))

I assume it is saying "put a 1 here" if....... certain criteria from the 2 sheets is met?

Why are both sheets mentioned twice ?

What IS the criteria!?!


Thanks
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

lozzablake

Well-known Member
Joined
Dec 15, 2005
Messages
818
No it is 1-

1) the sum of all items in range g3 to g223 that meet the criteria in b10 for range a3 to a119 (this may give an error as the two ranges should have the same rows ie it should be g3 to g119)

2) the sum of all items in range ba2 to ba373 that meet the criteria in b10 for range a2 to a373
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,634
Members
410,804
Latest member
bluepinky
Top