Hello guys,
this is my first post on this forum, I tryed a little search but I have not found the answer to my question. If I am wrong, please don't esitate to forward me to the right post or link.
Well, imagine to have a 13 column sheet where in A there is a simple description and in the subsequents column months from January to December.
I need to sum a specific description for a specific month that I need to select.
So, table could be like this:
Type January February
Cable 1.000€ 1.500€
Plug 500€ 250€
Cable 100€ 150E
I defined a named range called "February" and then a formula in A1000
A1000: =sumif(A1:Z300;"Cable";February)
and it does work! The result is 1.650€.
I would like to select the month under analisys and then I write in cell A999 the name of the named range previously defined:
A999: February
and then chanded A1000 in: =sumif(A1:Z300;"Cable";A999)
but unfortunatly it doesn't work...
How can I do to be able to select one of the named range previously defined and get the right sum?
thanks to all, I'll wait for your suggestion.
I hope to have well explained what I am looking for.
ciao
fausto
Bookmarks