Wildcarding cell references

BritishBuddha

New Member
Joined
Feb 9, 2011
Messages
14
I want a cell to be able to check each cell on row 1 using IF and if a specific value is present to COUNT/COUNTIF all cells from *3:*151 (where * denoted the coloumn of the cell checked)

Is wildcarding cell coloumns/rows possible? :confused:
I hope I've explained this correctly.

Thanks
 
That first link is broken, so can't see what you're on about.
 
Upvote 0
I can see your links now, but it doesn't make things any clearer. Can you explain the logic behind what you want to happen, in precise terms?
 
Upvote 0
In this screenshot: http://i52.tinypic.com/4ptbfl.jpg
Row two contains the weather on different dates,
A3 to A151 contains vehicle numbers,
B3:IV151 contain information on faults.

I'm trying to count how many times a fault occurred during specific types of weather for each vehicle. I want excel to cross reference all days that are 'WET' with all faults that contain the term 'DBF' and count them.
 
Upvote 0
The two words would be 'slight rain' so it would be treated the same as 'wet'. If this was a problem, rewording would be simple enough.

The last two weather conditions would be 'frosty' and 'dry'.
 
Upvote 0
And the cross-referencing .. WET with DBF ... your screenshot shows also:
DOORS
EB
FC4
FEC
FTD
NCT

Are these to be searched for simultaneously? Or what?
 
Upvote 0
No, I would be happy if I could get it to just check the 'wet' and 'dbf' for each single vehicle row. Then I could just swap other faults and weather conditions as needed.
 
Upvote 0
Here's a starting point:
Code:
=SUMPRODUCT(--(1:1="First check")*--(NOT( ISERROR(FIND("Second check",3:151)))))

.... like my first formula but operates on embedded text within the contents of cells, rather than whole cell contents.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top