asked on countifs formula with indirects
Hi Experts EXCEL 2010
Need a countifs formula to do the following:
If cell A1 sheet apple is red, then look in sheet pivot column b2 ('pivot'!b15:b200) range formula. And count all the reds in the data range and also look in column g2 ('pivot'!g15;g200) formula..and count the "(blank)"..to return the result.
Apologies unable to upload sample file.
Need a countifs formula to do the following:
If cell A1 sheet apple is red, then look in sheet pivot column b2 ('pivot'!b15:b200) range formula. And count all the reds in the data range and also look in column g2 ('pivot'!g15;g200) formula..and count the "(blank)"..to return the result.
Apologies unable to upload sample file.
Microsoft Excel
Last Comment
gowflow
when u say red you mean the font color or background color?
Can you post a sample please ?
gowflow
gowflow
ASKER
Hi how flow
Thanks for the feedback..nearly worked it out..how would I amend
=countifs(indirect('SheetN
THE ANSWER is 20 getting 0..cannot see my error
Thanks for the feedback..nearly worked it out..how would I amend
=countifs(indirect('SheetN
THE ANSWER is 20 getting 0..cannot see my error
=countifs(indirect('SheetN
You are missing something after te second SheetName or the ) is wrong what is it ? it gives an error
gowflow
You are missing something after te second SheetName or the ) is wrong what is it ? it gives an error
gowflow
ASKER
No error just returns zero value.
sorry but
indirect('SheetName'!)
means nothing
you need to have a cell after !
gowflow
indirect('SheetName'!)
means nothing
you need to have a cell after !
gowflow
ASKER
Sorry c3...and still zero..error in posting question on my part.
mmmm YOU from all the people in here should know better than that !!!!
let me see
let me see
Why don't you post this sample workbook and make my life easier !!!!
I tried
=COUNTIFS(INDIRECT(SheetNa
and get #REF! error
please if you need help help us when we ask for sample workbook
gowflow
I tried
=COUNTIFS(INDIRECT(SheetNa
and get #REF! error
please if you need help help us when we ask for sample workbook
gowflow
ASKER
I think it to do with < not begin recongised as text..
pls let us think ... we are here for that simply post a sample that has the data.
THANK YOU
gowflow
THANK YOU
gowflow
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.