IFSUM Tab

Oct 10, 2008

hi everyone, i have a formula in my spreadsheet that gets data from a worksheet called Graph Data,I have other worksheets that i would like to get data from by means of a drop down menu (6 sheets in all) the drop down link cell returns values of 1-6 and i have called the other worksheets simply 1 to 6, if i type 5 in place of Graph data then i get the required results so what i wanted to do was have the dropdown box link cell value dictate the worksheet tab in the formula below,i cant place the value in a cell (say A29) and then put A29 in place of graph data because it then looks for a tab called A29,i was wondering if this was possible to do and if anyone can help,many thanks,ive only just started on excel so im not that literate,ty

=IF(L60="Y",SUMIF('Graph Data'!$B:$B,L61,'Graph Data'!$C:$C)+SUMIF('Graph Data'!$B:$B,L61,'Graph Data'!$D:$D),"")

View 9 Replies


ADVERTISEMENT

Combination Of Ifsum And Indirect

Oct 17, 2007

i've attached a worksheet yet removed my attempt at formulas as it would have made most of you cry... what i'd like to do is select an item from a dropdown list (B1) (that i've built and it works, phew) and display the summary data (B3:B10) from the column or sum of columns in array (A12:F21) as explained in the relationship matrix.

I've tried ifsum and dsum (copied in each cell B3 to B10 of course) yet it doesn't extract items from the array with the drop-down selection. nor does it add columns together.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved