Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
sumif across sheets not working
0 views
Skip to first unread message
Me
Oct 15, 2005, 2:06:52 PM10/15/05
to
I want to use sumif on Sheet2 to select and sum values from Sheet1, but
all I get is #VALUE!. My function looks like:
all I get is #VALUE!. My function looks like:
=sumif(Sheet1!A1:A5,A1,Sheet1!B1:B5)
Sheet1
A1:Foo B1:1
A2:Bar B2:2
A3:Foo B3:3
A4:Bar B4:4
A5:Baz B5:5
Sheet2
A1:Foo B1:=sumif(Sheet1!A1:A5,A1,Sheet1!B1:B5)
Not sure where the problem is.
0 new messages