Cannot figure out how to combine two if statements.
Worksheet 1 has detail data:
x=Name
y=Category
z=Total
In Worksheet 2 I want to summarize:
If(x=name)
and
If(y=category)
give me
z(total)
=IF(($b$5=range),IF($a4=range),range))
Cannot figure out how to combine two if statements.
Worksheet 1 has detail data:
x=Name
y=Category
z=Total
In Worksheet 2 I want to summarize:
If(x=name)
and
If(y=category)
give me
z(total)
=IF(($b$5=range),IF($a4=range),range))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks